Re: after using pg_resetxlog, db lost

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: after using pg_resetxlog, db lost
Дата
Msg-id 40BC7970.3000500@archonet.com
обсуждение исходный текст
Ответ на after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Ответы Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Список pgsql-general
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

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

Предыдущее
От: "Levan, Jerry"
Дата:
Сообщение: Running Totals and other stuff....
Следующее
От: zhicheng wang
Дата:
Сообщение: Re: after using pg_resetxlog, db lost