| From: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can't pg_dumpall, claims database exists twice |
| Date: | 2005-03-28 17:08:28 |
| Message-ID: | BE6D881C.1F40C%scott_ribe@killerbytes.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> What's the result of the following query?
>
> SELECT tableoid, xmin, xmax, oid, datname, datdba,
> datvacuumxid, datfrozenxid
> FROM pg_database
> ORDER BY datname, oid;
tableoid | xmin | xmax | oid | datname | datdba | datvacuumxid |
datfrozenxid
----------+--------+------+--------+-----------+--------+--------------+----
----------
1262 | 3149 | 0 | 220622 | pedcard | 1 | 770122 |
3221995595
1262 | 787399 | 0 | 288848 | pedcard | 1 | 482 |
482
1262 | 539 | 0 | 17229 | template0 | 1 | 482 |
482
1262 | 538 | 0 | 1 | template1 | 1 | 482 |
482
(4 rows)
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-28 17:22:01 | Re: Can't pg_dumpall, claims database exists twice |
| Previous Message | Scott Ribe | 2005-03-28 17:08:23 | Re: Can't pg_dumpall, claims database exists twice |