Re: Recover anything from dropped database?

Поиск
Список
Период
Сортировка
От John D. Burger
Тема Re: Recover anything from dropped database?
Дата
Msg-id 79611E8F-DA74-4A6D-BC6B-6FBB9EDD3771@mitre.org
обсуждение исходный текст
Ответ на Re: Recover anything from dropped database?  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Recover anything from dropped database?  ("John D. Burger" <john@mitre.org>)
Список pgsql-general
> John D. Burger wrote:
>> With a slip of the keyboard, I just dropped a database I'd like to
>> have
>> back.  I don't have PITR or anything turned on - if nothing else has
>
> And no backups?
>
>> been done to the cluster since then, is there any way to recover
>> anything at all?

I have a backup as of last night, but I'd like to recover something
more recent if I can.  If I'm stuck with the backup, I can just stop
the postmaster, drop the whole PG directory into place from the
backup, and restart, yes?

Any advice welcome.  By the way, this is PG 7.4.

Thanks.

- John Burger

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

Предыдущее
От: Kenneth Downs
Дата:
Сообщение: Re: [ANNOUNCE] Advisory on possibly insecure security definer functions
Следующее
От: Walter Vaughan
Дата:
Сообщение: Re: Stored Procedure examples