Re: A real puzzler: ANY way to recover? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: A real puzzler: ANY way to recover?
Date
Msg-id 20050505174936.GA19346@dcc.uchile.cl
Whole thread Raw
In response to A real puzzler: ANY way to recover?  ("David F. Skoll" <dfs@roaringpenguin.com>)
Responses Re: A real puzzler: ANY way to recover?
List pgsql-admin
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 (<alvherre[@]dcc.uchile.cl>)
"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)

pgsql-admin by date:

Previous
From: Rosser Schwarz
Date:
Subject: Re: A real puzzler: ANY way to recover?
Next
From: "David F. Skoll"
Date:
Subject: Re: A real puzzler: ANY way to recover?