Re: [GENERAL] 2 versions running & using pg_dumpall

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

> 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

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  
|           |

Ralph Smith
smithrn@u.washington.edu