Re: Odd duplicate database

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
>