Hi,

I would like to upgrade a Suse 9.3 from postgres 8.0 to 8.1
(preferably), because I develop on my local machine which has postgres
8.1 installed (Suse 10.2), and then upload all to my Vserver.

I already ran into problems with my newer client and the older server
(backslash commands not running).

Do you have experience in doing this upgrade? Can it be done with all
the dependend clients in PHP and others?

Thanks,

Max Strobel

M. Strobel <str (AT) dummy (DOT) comm> wrote:
Did you install PostgreSQL and the dependent software (PHP) with RPMs?
Then you should probably ask the packager of the RPMs how to upgrade
the software.

If you build from source, you can follow the instructions in the online
manuals.

WARNING: You cannot upgrade from 8.0 to 8.1 just by replacing the software.
You will have to export the 8.0 database cluster with pg_dumpall and
restore the backup into a newly created 8.1 cluster.
An 8.1 server will refuse to start with an 8.0 database cluster.
This procedure is also described in the manuals.

It is probably best to install the new software in a location different from
the old one so that you can have both versions at the same time and have
a simple fallback scenario when Things Go Wrong.

Yours,
Laurenz Albe