Odd duplicate database
От | Madison Kelly |
---|---|
Тема | Odd duplicate database |
Дата | |
Msg-id | 496E430C.40701@alteeve.com обсуждение исходный текст |
Ответы |
Re: Odd duplicate database
Re: Odd duplicate database |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: