Wim Goedertier <Wim_Goedertier@symantec.com> writes:
> After studying http://www.postgresql.org/docs/8.2/static/app-pgresetxlog.html
> I ran:
> su <db-user> -c 'pg_resetxlog -f -x 0x9A00000 -m 0x10000 -O 0x10000 -l 0x1,0xB67,0x58 <PGDATA-directory>'
> and yes, it worked perfectly!
> After that I could pg_dump, drop database, create database and import the dump.
> Now, I'm verifying the consistency on the level of my application.
Great! But a word of warning: personally, I'd have re-initdb'd the
whole installation. When you have a problem like this, there's no good
reason to assume that only the active database is broken.
regards, tom lane
