Re: Recover anything from dropped database?

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recover anything from dropped database?
Date: 2007-02-14 22:14:56
Message-ID: 79611E8F-DA74-4A6D-BC6B-6FBB9EDD3771@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Walter Vaughan 2007-02-14 22:18:10 Re: Stored Procedure examples
Previous Message Kenneth Downs 2007-02-14 22:14:14 Re: [ANNOUNCE] Advisory on possibly insecure security definer functions