Re: 2 versions running & using pg_dumpall
| От | Ralph Smith |
|---|---|
| Тема | Re: 2 versions running & using pg_dumpall |
| Дата | |
| Msg-id | 9180A0D2-7930-4586-A143-D0A6C52A688E@u.washington.edu обсуждение исходный текст |
| Ответ на | Re: 2 versions running & using pg_dumpall (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: 2 versions running & using pg_dumpall
|
| Список | pgsql-general |
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 findinganything 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)
В списке pgsql-general по дате отправления: