Re: drop database - Mailing list pgsql-admin

From Jan Harasym
Subject Re: drop database
Date
Msg-id 669b943b551446a1a020f48b9b050930@pdc-mail-exch05.ubisoft.org
Whole thread Raw
In response to drop database  (Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>)
List 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
FortesCorrea
 
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

pgsql-admin by date:

Previous
From: Julio Leyva
Date:
Subject: Re: drop database
Next
From: Peter Eisentraut
Date:
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3