[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ProgSoc] postgresql upgrade



I've upgrade the postgres on both succubus and incubus so that they can
support multiple versions installed at the same time.  Incubus has 7.4
and 8.1 (on port 5433) installed.

Along the way I noticed:

postgres@incubus:~$ psql membership
Welcome to psql 7.4.7, 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

membership=# \d
No relations found.
membership=# \q
postgres@incubus:~$ psql progsoc
Welcome to psql 7.4.7, 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

progsoc=# \d
No relations found.
progsoc=# \q
postgres@incubus:~$

i.e. no actual data to backup.

There should be no need to change anything in your scripts, web pages,
etc., unless you want to use postgres 8.1

Anand

-- 
 `When any government, or any church for that matter, undertakes to say to
  its subjects, "This you may not read, this you must not see, this you are
  forbidden to know," the end result is tyranny and oppression no matter how
  holy the motives' -- Robert A Heinlein, "If this goes on --"

-
You are subscribed to the progsoc mailing list. To unsubscribe, send a
message containing "unsubscribe" to progsoc-request@xxxxxxxxxxxxxxxxxxx
If you are having trouble, ask owner-progsoc@xxxxxxxxxxxxxxxxxx for help.