Mysterious empty database name?

From: Azlin Rahim <azlin(dot)rahim(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Mysterious empty database name?
Date: 2010-05-25 22:23:13
Message-ID: AANLkTikmXvuDYIxdTu3HEBHKybtgsPdw70Vz_cozGOpM@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In our database list, there is one 'mysterious' database with a blank name.
We don't know how it got there.

Below is the output of pg_database. Does anyone have any idea why this is
happening? Any way to remove the 'mysterious' database safely.

datname | datdba | encoding | datistemplate |
datallowconn | datconnlimit | datlastsysoid | datvacuumxid | datfrozenxid |
dattablespace | datconfig | datacl
---------------------------+--------+----------+---------------+--------------+--------------+---------------+--------------+--------------+---------------+-----------+------------------------
postgres | 10 | 6 | f | t
| -1 | 10792 | 38260524 | 3259485997 |
1663 | |
jboss-ktj-2007-09-02 | 10 | 6 | f | t
| -1 | 10792 | 38260579 | 3259486052 |
1663 | |
jboss-ktj | 10 | 6 | f | t
| -1 | 10792 | 38261114 | 3259486587 |
1663 | |
jboss-ktj-test-2010-03-28 | 10 | 6 | f | t
| -1 | 10792 | 38261842 | 3259487315 |
1663 | |
jboss-warestore | 10 | 6 | f | t
| -1 | 10792 | 38262572 | 3259488045 |
1663 | |
template1 | 10 | 6 | t | t
| -1 | 10792 | 38262629 | 3259488102 |
1663 | | {postgres=CT/postgres}
template0 | 10 | 6 | t | f
| -1 | 10792 | 499 | 499 |
1663 | | {postgres=CT/postgres}
jboss-ktj-test | 10 | 6 | f | t
| -1 | 10792 | 38262684 | 3259488157 |
1663 | |
| 10 | 6 | f | t |
-1 | 10792 | 499 | 499 | 1663 |
| <--- 'Mysterious' database

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-05-25 22:40:00 Re: Mysterious empty database name?
Previous Message Goran Hasse 2010-05-25 21:21:30 Re: How to fetch values at regular hours?