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

From zhicheng wang
Subject Re: after using pg_resetxlog, db lost
Date
Msg-id 20040601134303.77247.qmail@web51010.mail.yahoo.com
Whole thread Raw
In response to Re: after using pg_resetxlog, db lost  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: after using pg_resetxlog, db lost  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
hi, thanks

rhdb is the postgresql for redhat ELAS3

it could not start and the error is attached

thanks

cheng


 --- Alvaro Herrera <alvherre@dcc.uchile.cl> wrote: >
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)
>

=====
Best wishes
Z C Wang





____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

Attachment

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: after using pg_resetxlog, db lost
Next
From: "Chris Ochs"
Date:
Subject: db design question