Re: after using pg_resetxlog, db lost

Поиск
Список
Период
Сортировка
От zhicheng wang
Тема Re: after using pg_resetxlog, db lost
Дата
Msg-id 20040601124936.91786.qmail@web51001.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: after using pg_resetxlog, db lost  (Richard Huxton <dev@archonet.com>)
Ответы Re: after using pg_resetxlog, db lost  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: after using pg_resetxlog, db lost  (Richard Huxton <dev@archonet.com>)
Re: after using pg_resetxlog, db lost  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Dear Richard
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

please help

cheng



 --- Richard Huxton <dev@archonet.com> wrote: >
zhicheng wang wrote:
> > dear all
> > after we shutdown the rh_postgres-server 7.3.6,
> rhdb
> > could not start. we tried
> >
> > pg_resetxlog -f PGDATA
> >
> > then the server can be started, but only template0
> and
> > template1 db available.
> >
> > our database not listed.
>
> Was there a crash?
> What do your logs say?
> How much disk space does your /data/base directory
> use and is that
> enough for your data?
> Do you have your backups available?
>
> --
>    Richard Huxton
>    Archonet Ltd

=====
Best wishes
Z C Wang





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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: after using pg_resetxlog, db lost
Следующее
От: "Stijn Vanroye"
Дата:
Сообщение: Re: Large table search question[Scanned]