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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Marcelo Fortes Correa Fortes Correa Sent: December 05, 2014 1:57 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: 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@xxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
