Re: drop database

From: Julio Leyva <jcleyva(at)hotmail(dot)com>
To: John Scalia <jayknowsunix(at)gmail(dot)com>, Marcelo Fortes Correa Fortes Correa <marcelofortescorrea(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: drop database
Date: 2014-12-05 14:14:56
Message-ID: COL131-W2385C8F4953E1E28839430A1790@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Once thing will save you is if you had PITR in place, so you can apply logs back to the DB......If not as Jay said,,,no mechanisms to recover it.

> Date: Fri, 5 Dec 2014 08:49:58 -0500
> From: jayknowsunix(at)gmail(dot)com
> To: marcelofortescorrea(at)gmail(dot)com; pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] drop database
>
> I'm afraid that the answer (to my knowledge) is you're out of luck. Without a backup to recover from, I know of NO mechanisms to recover this data.
>
> Sorry,
> Jay
>
> On 12/5/2014 7:56 AM, Marcelo Fortes Correa Fortes Correa wrote:
> > I have a problem, a base was deleted with "drop database", I do not
> > have backup or archives ...
> >
> > How can I recover this database?
> > PostgreSQL 9.1 ....
> > ----------------------------------------------------------------------------------
> > Marcelo Fortes Corrêa
> > E-mail: marcelofortescorrea(at)gmail(dot)com
> > Telefone: (47) 9131-8022
> > P Somente imprima este e-mail se necessário, ser sustentável é
> > nosso compromisso.
> >
> >
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2014-12-06 03:51:48 Re: Problem pg_upgradecluster from 9.1 to 9.3
Previous Message Geoff Winkless 2014-12-05 14:13:03 Re: drop database