Forgot to mention, this is PostgreSQL 8.3.5 on Linux (Ubuntu 8.10, hey,
it's a devel machine!). :)
Madi
Madison Kelly wrote:
Hi all,
My devel server has some wierdness happening. I tried to drop the
database (reload from a copy from the production server) and I got this
weird error:
pg_dump: query returned more than one (2) pg_database entry for database
"nexxia"
So I logged in as postgres and checked, and sure enough:
template1=# \l
List of databases
Name | Owner | Encoding
------------+----------+----------
deadswitch | digimer | UTF8
nexxia | digimer | UTF8
nexxia | digimer | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(6 rows)
So I tried to drop the database(s?) from the shell:
template1=# DROP DATABASE nexxia ;
DROP DATABASE
template1=# \l
List of databases
Name | Owner | Encoding
------------+----------+----------
deadswitch | digimer | UTF8
nexxia | digimer | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
(5 rows)
template1=# DROP DATABASE nexxia ;
ERROR: database "nexxia" does not exist
So I still have a phantom DB there. This is still true after stopping
and restarting the daemon, too. When I try to connect to the database I
get this:
template1=# \c nexxia
FATAL: database "nexxia" does not exist
Previous connection kept
Does this mean a connection is still open somewhere? If so, how did it
survive the daemon restarting? More specifically, how do I clear it?
Thanks!
Madi
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
