Re: [GENERAL] 2 versions running & using pg_dumpall

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

> Ralph Smith <smithrn@u.washington.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@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

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.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

Ralph Smith
smithrn@u.washington.edu

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly