PostgreSQL 8.3 has entered Debian (unstable).

To upgrade an existing database, run the following commands:

aptitude install postgresql-8.3

At this point, two versions are installed: 8.2 and 8.3.

The installation will create a cluster for version 8.3. We need to drop it before upgrading:

pg_dropcluster --stop 8.3 main

Now, we can upgrade the cluster:

pg_upgradecluster -v 8.3 8.2 main

After check that everything is ok, the old cluster can be removed:

pg_dropcluster --stop 8.2 main

And the packages for 8.2 can be removed:

aptitude remove postgresql-8.2

---

Written by Pierre Chifflier on 2008/01/21