Re: [URGENT] Problems recovering database - Mailing list pgsql-admin

From Tom Lane
Subject Re: [URGENT] Problems recovering database
Date
Msg-id 3500.1052948416@sss.pgh.pa.us
Whole thread Raw
In response to Re: [URGENT] Problems recovering database  (Bruno Mattarollo <bruno@web1.greenpeace.org>)
Responses Re: [URGENT] Problems recovering database  (Bruno Mattarollo <bruno@web1.greenpeace.org>)
List pgsql-admin
Bruno Mattarollo <bruno@web1.greenpeace.org> writes:
> Thanks for the tip. It worked to start the DB but when I issue:
> psql -l
> I can't see my databases :(

You need to set the next transaction ID higher (pg_resetxlog -x).
I'd try 2 billion (2000000000) for starters.

You should probably also be setting the WAL start location (-l)
somewhere past the evidently-already-existing segments ("-l 2,0"
should do, I think).

Needless to say, initdb and reload as soon as you have managed to
get a good dump.

            regards, tom lane

pgsql-admin by date:

Previous
From: Bruno Mattarollo
Date:
Subject: Re: [URGENT] Problems recovering database
Next
From: Bruno Mattarollo
Date:
Subject: Re: [URGENT] Problems recovering database