Re: [GENERAL] 2 versions running & using pg_dumpall

From: Ralph Smith <smithrn(at)u.washington.edu>
Date: Thu Oct 25 2007 - 18:59:58 EDT

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

> ./psql template1 -p 5433

---

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

Ralph Smith
smithrn@u.washington.edu

---

Received on Thu Oct 25 19:05:31 2007