Quick Links

A real puzzler: ANY way to recover?

From:	"David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	A real puzzler: ANY way to recover?
Date:	2005-05-05 17:14:26
Message-ID:	427A5472.8060004@roaringpenguin.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-hackers

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.

Responses

Re: A real puzzler: ANY way to recover? at 2005-05-05 17:34:29 from Tom Lane
Re: A real puzzler: ANY way to recover? at 2005-05-05 17:37:42 from Rosser Schwarz
Re: A real puzzler: ANY way to recover? at 2005-05-05 17:49:36 from Alvaro Herrera
Re: A real puzzler: ANY way to recover? at 2005-05-05 18:19:15 from Tom Lane

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Tom Lane	2005-05-05 17:34:29	Re: A real puzzler: ANY way to recover?
Previous Message	erik	2005-05-05 13:49:21	GetAvailableLocales aborting installation

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Josh Berkus	2005-05-05 17:17:44	Re: Views, views, views! (long)
Previous Message	Marc G. Fournier	2005-05-05 17:05:55	Re: [pgsql-advocacy] Increased company involvement