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

From Bruno Mattarollo
Subject Re: [URGENT] Problems recovering database
Date
Msg-id Pine.LNX.4.33.0305150137180.18610-100000@web1.greenpeace.org
Whole thread Raw
In response to Re: [URGENT] Problems recovering database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hello Tom,

Thank you very much. This seems to have done the trick. I can now access
the database and did a pg_dump ... Will now load this data into a PGSQL
7.3.2 ...

Thanks again to you and Bjoern (previous email) for the help!!! :)

Cheers

/B

On Wed, 14 May 2003, Tom Lane wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--

--- Bruno Mattarollo <bruno@web1.greenpeace.org> ---
    SysAdmin & TechLead - Greenpeace International
    http://www.greenpeace.org/
----------------------------------------------------



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [URGENT] Problems recovering database
Next
From: timeless postgres
Date:
Subject: Re: No flamefest please, MySQL vs. PostgreSQL AGAIN