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: (view raw or whole thread)
Lists: pgsql-adminpgsql-hackers

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? :-(




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-2015 The PostgreSQL Global Development Group