From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Devrim GÜNDÜZ <devrim(at)CommandPrompt(dot)com> |
Subject: | Re: 2 versions running & using pg_dumpall |
Date: | 2007-10-25 22:59:58 |
Message-ID: | D177D296-2129-4DDE-B840-988377766930@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
=====================
From | Date | Subject | |
---|---|---|---|
Next Message | Pat Maddox | 2007-10-25 23:13:05 | Selecting tree data |
Previous Message | Devrim GÜNDÜZ | 2007-10-25 22:45:46 | Re: 2 versions running & using pg_dumpall |