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 22:34:18
Message-ID: 3844.1052951658@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:
> Thank you for this. Setting the transaction ID higher worked to allow me
> to connect to the database but when I issue:

> cybercentre=# select count(*) from users;
> ERROR: XLogFlush: request 10/B7E93FCC is not satisfied --- flushed only
> to 0/4000050

> I get that error. Any idea?

Looks like the starting WAL location needs to be higher than I thought.
Try "-l 100,0".

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Mattarollo 2003-05-14 23:38:30 Re: [URGENT] Problems recovering database
Previous Message Bruno Mattarollo 2003-05-14 22:02:20 Re: [URGENT] Problems recovering database