Re: 2 versions running & using pg_dumpall

On Oct 25, 2007, at 3:45 PM, Devrim GÜNDÜZ wrote:

> ./psql template1 -p 5433

=================================================
postgres(at)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

Ralph Smith
smithrn(at)u(dot)washington(dot)edu
=====================