Wim Goedertier <Wim_Goedertier@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
