Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group