Re: Can't pg_dumpall, claims database exists twice

> select ctid,oid,xmin,cmin,xmax,cmax,* from pg_database

ctid | oid | xmin | cmin | xmax | cmax | datname | datdba |
encoding | datistemplate | datallowconn | datlastsysoid | datvacuumxid |
datfrozenxid | dattablespace | datconfig | datacl
-------+--------+--------+------+------+------+-----------+--------+--------
--+---------------+--------------+---------------+--------------+-----------
---+---------------+-----------+------------------------
(0,1) | 288848 | 787399 | 0 | 0 | 0 | pedcard | 1 |
0 | f | t | 17228 | 482 |
482 | 1663 | |
(0,3) | 220622 | 3149 | 0 | 0 | 0 | pedcard | 1 |
0 | f | t | 17228 | 770122 |
3221995595 | 1663 | |
(0,6) | 1 | 538 | 0 | 0 | 0 | template1 | 1 |
0 | t | t | 17228 | 482 |
482 | 1663 | | {postgres=CT/postgres}
(0,7) | 17229 | 539 | 0 | 0 | 0 | template0 | 1 |
0 | t | f | 17228 | 482 |
482 | 1663 | | {postgres=CT/postgres}
(4 rows)

--
Scott Ribe
scott_ribe(at)nospam(dot)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice