Re: Upgrading from 8.0 to 8.1 on Debian

* Assad Jarrahian (jarraa(at)gmail(dot)com) wrote:
> jarraa(at)proximity:/etc/postgresql-common$ sudo pg_upgradecluster 8.0 main
> Error: target cluster 8.1/main already exists

This is complaining that you already did an initdb on the 8.1 version, I
believe.

> What would be the step by step process in this case? I would like to
> backup the db (plus its data), then point everything to the new
> Postgresql version and get all my db's on to that.

Basically you should be able to modify
/etc/postgresql/8.1/postmaster.conf (iirc) and get the 8.1 postmaster
running on some alternate port. You can then use pg_restore to load up
all your data from your 8.0 install into your 8.1 install. Then you
just need to stop your 8.0 postmaster, modify the port for your 8.1
postmaster to the 'normal' one and restart it.

Basically, Debian lets you have both installed. Once you're happy with
your 8.1 install you can remove/purge your 8.0 packages. Just to note:
I havn't actually done this myself yet (been thinking about it though).
Also, this isn't entirely appropriate for this list (being
a Debian-specific question). You can file a bug on
http://bugs.debian.org asking for additional documentation to be
included in the package, or if you run into problems.

Enjoy,

Stephen