Re: 2 versions running & using pg_dumpall

[Ralph Smith <smithrn@xxxxxxxxxxxxxxxx>]

On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:

Ralph Smith <smithrn@xxxxxxxxxxxxxxxx> 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

===============================================

Oops. And I thought I got over NOT using the full path to the commands...

Sorry about that.

postgres@smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql

Welcome to psql 7.4.13, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms

       \h for help with SQL commands

       \? for help on internal slash commands

       \g or terminate with semicolon to execute query

       \q to quit

postgres=# select * from pg_database ;

  datname  | datdba | encoding | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | dattablespace | datconfig |               datacl               

-----------+--------+----------+---------------+--------------+--------------+---------------+--------------+---------------+-----------+-------------------------------------

postgres  |     10 |        6 | f             | t            |           -1 |         10818 |          524 |          1663 |           |

template1 |     10 |        6 | t             | t            |           -1 |         10818 |          524 |          1663 |           | {=c/postgres,postgres=CTc/postgres}

template0 |     10 |        6 | t             | f            |           -1 |         10818 |          524 |          1663 |           | {=c/postgres,postgres=CTc/postgres}

airburst  |  17032 |        0 | f             | t            |           -1 |         10818 |          524 |          1663 |           |

(4 rows)

Ralph Smith

smithrn@xxxxxxxxxxxxxxxx

=====================