pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddrop database
5+ messages / 5 participants
[nested] [flat]
* drop database
@ 2014-12-05 12:56 Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>
2014-12-05 13:39 ` Re: drop database Jan Harasym <jan.harasym@massive.se>
2014-12-05 13:49 ` Re: drop database John Scalia <jayknowsunix@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Marcelo Fortes Correa Fortes Correa @ 2014-12-05 12:56 UTC (permalink / raw)
To: pgsql-admin
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@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: drop database
2014-12-05 12:56 drop database Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>
@ 2014-12-05 13:39 ` Jan Harasym <jan.harasym@massive.se>
1 sibling, 0 replies; 5+ messages in thread
From: Jan Harasym @ 2014-12-05 13:39 UTC (permalink / raw)
To: Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>; pgsql-admin
AFAIK, once a database is dropped, it's gone. That's kinda the point in
dropping it. So a backup is the surest way to go. Also, since
you're going to have start from a fresh restore of your backup, I'd
recommend upgrading to a more recent version of Postgres, at least 9.3.x
if not the most recent which is 9.3.5.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Marcelo Fortes Correa Fortes Correa
Sent: December 05, 2014 1:57 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] drop database
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@gmail.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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: drop database
2014-12-05 12:56 drop database Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>
@ 2014-12-05 13:49 ` John Scalia <jayknowsunix@gmail.com>
2014-12-05 14:13 ` Re: drop database Geoff Winkless <pgsqladmin@geoff.dj>
2014-12-05 14:14 ` Re: drop database Julio Leyva <jcleyva@hotmail.com>
1 sibling, 2 replies; 5+ messages in thread
From: John Scalia @ 2014-12-05 13:49 UTC (permalink / raw)
To: Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>; pgsql-admin
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@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: drop database
2014-12-05 12:56 drop database Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>
2014-12-05 13:49 ` Re: drop database John Scalia <jayknowsunix@gmail.com>
@ 2014-12-05 14:13 ` Geoff Winkless <pgsqladmin@geoff.dj>
1 sibling, 0 replies; 5+ messages in thread
From: Geoff Winkless @ 2014-12-05 14:13 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Well you could try to persuade Hendo to stop working on the hoverboard and
move on to the flux capacitor instead...
On 5 December 2014 at 13:49, John Scalia <jayknowsunix@gmail.com> wrote:
> 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@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: drop database
2014-12-05 12:56 drop database Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>
2014-12-05 13:49 ` Re: drop database John Scalia <jayknowsunix@gmail.com>
@ 2014-12-05 14:14 ` Julio Leyva <jcleyva@hotmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Julio Leyva @ 2014-12-05 14:14 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>; 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@gmail.com
> To: marcelofortescorrea@gmail.com; pgsql-admin@postgresql.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@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
=
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-12-05 14:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-05 12:56 drop database Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>
2014-12-05 13:39 ` Jan Harasym <jan.harasym@massive.se>
2014-12-05 13:49 ` John Scalia <jayknowsunix@gmail.com>
2014-12-05 14:13 ` Geoff Winkless <pgsqladmin@geoff.dj>
2014-12-05 14:14 ` Julio Leyva <jcleyva@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox