Search Postgresql Archives

Re: 2 versions running & using pg_dumpall

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux