Re: pg_log deleted - what to do?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_log deleted - what to do?
Дата
Msg-id 200010011801.OAA09849@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_log deleted - what to do?  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: pg_log deleted - what to do?  (Ralf Tschiersch <ralf@net-service.de>)
Re: pg_log deleted - what to do?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-admin
Can the user rename the /data directory, do initdb, save the pg_log
file, move the old /data back into place, add the new pg_log, and do a
backup of his data?

I thought this would work, but am not sure.

> Ralf Tschiersch writes:
>
> > don't ask why, but what can I do if I have pg_log accidently deleted? How
> > to recover? the postmaster starts, I can connect do databases, but neiter
> > tables nor sequences are found! Postgres is 6.5.3 on linux 2.2.10.
>
> You have pretty much lost.  Deleting pg_log is almost like deleting the
> data itself.  You make backups, don't you?
>
> --
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
>
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_log deleted - what to do?
Следующее
От: Ralf Tschiersch
Дата:
Сообщение: Re: pg_log deleted - what to do?