Re: 2 versions running & using pg_dumpall

On Oct 25, 2007, at 1:57 PM, Tom Lane wrote:

> Ralph Smith <smithrn(at)u(dot)washington(dot)edu> writes:
>> On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:
>>> Ummm ... those are the column headings for 8.2 pg_database, not 7.4.
>>> You're looking at the wrong postmaster.
>
>> postgres(at)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
>
> Still the wrong column headings :-(. What you have above is a 7.4
> psql
> connecting to an 8.2 postmaster, no doubt because the default port
> number wired into it is the 8.2 installation's not the 7.4 one's.
> You'll need to explicitly give a -p switch to psql to connect to the
> correct postmaster.
>
> regards, tom lane
===========================================
postgres(at)smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433
psql: FATAL: database "postgres" does not exist

looks like I have to re-install PG 7.4. There's only only 41 MB there.

On Ubuntu, what are my options?
Use Synaptic to uninstall?

Once that's done, any caveats WRT the subsequent install?

All this is so I can practice and make mistakes here on test boxes
before w move the real on from 7.4 to 8.2.

Thanks a bunch Tom.

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