Re: [URGENT] Problems recovering database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Mattarollo <bruno(at)web1(dot)greenpeace(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [URGENT] Problems recovering database
Date: 2003-05-14 21:40:16
Message-ID: 3500.1052948416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruno Mattarollo <bruno(at)web1(dot)greenpeace(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Mattarollo 2003-05-14 22:02:20 Re: [URGENT] Problems recovering database
Previous Message Björn Metzdorf 2003-05-14 21:01:22 Re: [URGENT] Problems recovering database