Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43111=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XwtGr-0002vA-TM
 for pgsql-admin@arkaria.postgresql.org; Fri, 05 Dec 2014 13:50:10 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43111=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XwtGq-0006aA-R8
 for pgsql-admin@arkaria.postgresql.org; Fri, 05 Dec 2014 13:50:08 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <jayknowsunix@gmail.com>)
 id 1XwtGo-0006Yq-LE
 for pgsql-admin@postgresql.org; Fri, 05 Dec 2014 13:50:06 +0000
Received: from mail-yk0-x231.google.com ([2607:f8b0:4002:c07::231])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <jayknowsunix@gmail.com>)
 id 1XwtGl-0004ao-NB
 for pgsql-admin@postgresql.org; Fri, 05 Dec 2014 13:50:04 +0000
Received: by mail-yk0-f177.google.com with SMTP id 9so305667ykp.22
 for <pgsql-admin@postgresql.org>; Fri, 05 Dec 2014 05:50:02 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:date:from:user-agent:mime-version:to:subject:references
 :in-reply-to:content-type:content-transfer-encoding;
 bh=ft/TgC7BwOvEdqx+RVIaje/lxXLw8wUXr32Q2sMEWIQ=;
 b=YaQEUPlc80/inyOU1MMAZ9jOVbBP3DD0LfSjuZtLr87hmnLchh6tjx/EoyxR4PV97o
 wwi1f4wLWARO1R0XNZDL+KrfflR/uVZpeCD6Oapc953McENA7cE25HcUR5VPHkj5CRSB
 ECcpp1zqWptZh47/6990AAyQObWCd8Q06xejWM2PZGSwHPzOL7E/m2wlHm2E+NzjX3m2
 BH+frga0jDL+QGlI0/GuE4qeI1DLo1CNujWW/3dQXP/+Rm9ZtBq1imnOWhrfTp5Qxhlb
 xyyFfDn2oGAu0ixDXQ0Cyn5+QxOrImlNtb1oqxK6ZSTJSA2YgTyGRJdoflY9pD8ZIXX0
 /5Qw==
X-Received: by 10.170.66.207 with SMTP id i198mr22575879yki.26.1417787402417;
 Fri, 05 Dec 2014 05:50:02 -0800 (PST)
Received: from [192.168.254.2] (h77.89.102.166.static.ip.windstream.net.
 [166.102.89.77])
 by mx.google.com with ESMTPSA id z65sm17932357yha.44.2014.12.05.05.50.01
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 05 Dec 2014 05:50:01 -0800 (PST)
Message-ID: <5481B806.8080303@gmail.com>
Date: Fri, 05 Dec 2014 08:49:58 -0500
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: Marcelo Fortes Correa Fortes Correa <marcelofortescorrea@gmail.com>,
 pgsql-admin@postgresql.org
Subject: Re: drop database
References: 
 <CAO9GEEYmhN4OCosg1tJsqezQu=JPVpxZMtwWpMj+hWbNn3tdjQ@mail.gmail.com>
In-Reply-To: 
 <CAO9GEEYmhN4OCosg1tJsqezQu=JPVpxZMtwWpMj+hWbNn3tdjQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -1.7 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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