Re: [GENERAL] 2 versions running & using pg_dumpall

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Thu Oct 25 2007 - 16:09:28 EDT

Ralph Smith <smithrn@u.washington.edu> writes:
> On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:

>> Hmph.  Nothing obviously wrong there, except that it's not finding
>> anything except template1.  What does "select * from pg_database"
>> show?

> postgres=# select * from pg_database ;
> datname | datdba | encoding | datistemplate | datallowconn |
> datconnlimit | datlastsysoid | datfrozenxid | dattablespace |
> datconfig | datacl
> -----------+--------+----------+---------------+--------------
> +--------------+---------------+--------------+---------------
> +-----------+-------------------------------------

Ummm ... those are the column headings for 8.2 pg_database, not 7.4. You're looking at the wrong postmaster.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------

TIP 6: explain analyze is your friend Received on Thu Oct 25 16:13:06 2007