Mysterious empty database name?
| От | Azlin Rahim |
|---|---|
| Тема | Mysterious empty database name? |
| Дата | |
| Msg-id | AANLkTikmXvuDYIxdTu3HEBHKybtgsPdw70Vz_cozGOpM@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Mysterious empty database name?
Re: Mysterious empty database name? |
| Список | 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
В списке pgsql-general по дате отправления: