X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BE240535C1 for ; Thu, 5 May 2005 14:14:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03951-02 for ; Thu, 5 May 2005 17:14:29 +0000 (GMT) Received: from www.roaringpenguin.com (www.roaringpenguin.com [206.191.13.82]) by svr1.postgresql.org (Postfix) with ESMTP id DE0B653485 for ; Thu, 5 May 2005 14:14:27 -0300 (ADT) Received: from hydrogen.roaringpenguin.com (ottawa-hs-64-26-171-99.s-ip.magma.ca [64.26.171.99]) by www.roaringpenguin.com (8.13.4/8.13.1) with ESMTP id j45HERpx001725 for ; Thu, 5 May 2005 13:14:27 -0400 Received: from [192.168.10.1] (hydrogen.roaringpenguin.com [192.168.10.1]) by hydrogen.roaringpenguin.com (8.12.8/8.12.8) with ESMTP id j45HEQ2R005316 for ; Thu, 5 May 2005 13:14:27 -0400 Message-ID: <427A5472.8060004@roaringpenguin.com> Date: Thu, 05 May 2005 13:14:26 -0400 From: "David F. Skoll" User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: A real puzzler: ANY way to recover? X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-CanItPRO-Stream: outgoing X-Scanned-By: CanIt (www . roaringpenguin . com) on 206.191.13.82 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/49 X-Sequence-Number: 17478 Hi, Supposing someone stupidly did this: UPDATE pg_database SET datallowconn = false; and then closed all the connections to the server. Is there any way to recover short of nuking everything and restoring from a backup dump? :-( Regards, David.