Postgres Pro
Downloads
Home   >   mailing lists

Re: Recover anything from dropped database? - Mailing list pgsql-general

From John D. Burger
Subject Re: Recover anything from dropped database?
Date
Msg-id 79611E8F-DA74-4A6D-BC6B-6FBB9EDD3771@mitre.org
Whole thread Raw
In response to Re: Recover anything from dropped database?  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Recover anything from dropped database?  ("John D. Burger" <john@mitre.org>)
List pgsql-general
Tree view 
> 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 by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: [ANNOUNCE] Advisory on possibly insecure security definer functions
Next
From: Walter Vaughan
Date:
Subject: Re: Stored Procedure examples