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
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? |