On Oct 25, 2007, at 3:45 PM, Devrim GÜNDÜZ wrote:
================================================= postgres@smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433 template1 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 template1=# \l List of databases Name | Owner | Encoding -----------+----------+---------- template0 | postgres | UNICODE template1 | postgres | UNICODE (2 rows) template1=# select * from pg_database ; datname | datdba | encoding | datistemplate | datallowconn | datlastsysoid | datvacuumxid | datfrozenxid | datpath | datconfig | datacl -----------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------+-----------+-------------------------- template1 | 1 | 6 | t | t | 17140 | 7251 | 3221232724 | | | {postgres=C*T*/postgres} template0 | 1 | 6 | t | f | 17140 | 464 | 464 | | | {postgres=C*T*/postgres} (2 rows) Whoooo hoooo! Now we're back to square one. I can re-make postgres on v7.4 (already done) go back to my old dumpall and use that 7.4 dumpall to load PG 7.4 Remove the test DB from 8.2 as the dumpall that loaded it was via 7.4 not 8.2 use 8.2's dumpall to dump the 7.4 use 8.2's psql to load in that dump |
