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 3A00B53A26 for ; Thu, 5 May 2005 14:49:47 -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 09883-10 for ; Thu, 5 May 2005 17:49:38 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1E205535C1 for ; Thu, 5 May 2005 14:49:37 -0300 (ADT) Received: from anakena.dcc.uchile.cl (anakena [192.80.24.6]) by sunsite.dcc.uchile.cl (8.13.4/8.12.11) with ESMTP id j45Hna4b007245; Thu, 5 May 2005 13:49:36 -0400 (CLT) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 882D652D4E; Thu, 5 May 2005 13:49:36 -0400 (CLT) Date: Thu, 5 May 2005 13:49:36 -0400 From: Alvaro Herrera To: "David F. Skoll" Cc: pgsql-admin@postgresql.org Subject: Re: A real puzzler: ANY way to recover? Message-ID: <20050505174936.GA19346@dcc.uchile.cl> References: <427A5472.8060004@roaringpenguin.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <427A5472.8060004@roaringpenguin.com> User-Agent: Mutt/1.5.8i X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-1.6 (sunsite.dcc.uchile.cl [192.80.24.2]); Thu, 05 May 2005 13:49:36 -0400 (CLT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.339 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200505/52 X-Sequence-Number: 17481 On Thu, May 05, 2005 at 01:14:26PM -0400, David F. Skoll wrote: > 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? :-( Connect in standalone mode? -- Alvaro Herrera () "Ellos andaban todos desnudos como su madre los parió, y también las mujeres, aunque no vi más que una, harto moza, y todos los que yo vi eran todos mancebos, que ninguno vi de edad de más de XXX años" (Cristóbal Colón)