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

Bruno Mattarollo <bruno@web1.greenpeace.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