I downloaded a hex editor, but honestly, I can't make heads or tails of
what I'm looking at. I'm not sure what needs changing.
Also, FYI, you mentioned that you thought I had deleted the record with
ctid=(0,2). I did delete that, but thats what caused the database to
not work. I restored a backup copy of the data directory I had made
yesterday morning before I started messing with it.
If I restored the data directory again wouldn't that undo the Vacuum
Freeze command that I did that has locked the database into the state
that it is in now?
Tom Lane wrote:
Adam Dear <adear@xxxxxxxx> writes:
I'm comfortable enough with it that I can edit it if I can find exactly
what to edit. Whats the best way to edit the file? I've opened it using:
vim -b 1260
Here is what is at the end of the block in the file. If you could point
me in the right direction, I'd appreciate it.
I think you need to change T^B to ^B^@ ... though I agree with Alvaro
that a hex editor would be a more comfortable tool.
regards, tom lane
