On Oct 25, 2007, at 1:57 PM, Tom Lane wrote:
Ralph Smith <smithrn@xxxxxxxxxxxxxxxx> 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
===========================================
postgres@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@xxxxxxxxxxxxxxxx
=====================
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
