while you weren't looking, David F. Skoll wrote:
> Is there any way to recover short of nuking everything and
> restoring from a backup dump? :-(
I don't have any ability to test this and see if it actually works,
but a priori, I'd suggest trying, as your postgres user:
$ createdb oopswow
$ psql oopswow
oopswow=# update pg_database set datallowconn = true; -- with optional
WHERE clause
oopswow=# \q
That should work. Unless the new database takes its datallowconn
attribute from the template database, which will have been set to
false by the errant UPDATE -- in which case, I've no idea.
/rls
--
:wq
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
