Re: after using pg_resetxlog, db lost - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: after using pg_resetxlog, db lost
Date
Msg-id 20040601133957.GA26245@dcc.uchile.cl
Whole thread Raw
In response to Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Responses Re: after using pg_resetxlog, db lost
List pgsql-general
On Tue, Jun 01, 2004 at 01:49:36PM +0100, zhicheng wang wrote:

> it was not a crash. we issued poweroff command, then
> we used a dos floppy to upgrade bios on the fibrecard.
>  then when we reboot into the redhat AS3, the rhdb
> could not start.
>
> the log is attached.
>
> after using pg_resetxlog, we cannot see our db, only
> template0/1 listed by psql -l

Why did you issue the pg_resetxlog command at all?  Did the database
refuse to start?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Java is clearly an example of a money oriented programming"  (A. Stepanov)


pgsql-general by date:

Previous
From: jseymour@linxnet.com (Jim Seymour)
Date:
Subject: Re: Running Totals and other stuff....
Next
From: zhicheng wang
Date:
Subject: Re: after using pg_resetxlog, db lost