Sunday, October 3, 2010

upgrading PostgreSQL on Debian/Ubuntu

I've been upgrading pg on a few servers today. One from 8.1 to 8.4 (debian) and the other from 8.2 to 8.4 (ubuntu). In both cases the process worked as noted here (though I used aptitude):
  1. backup your db(s)

  2. add backports repositories ubuntu, debian instructions (don't forget about pinning)
aptitude install postgresql-8.4
pg_dropcluster --stop 8.4 main
pg_upgradecluster 8.1 main

Once you're sure that's working:
pg_dropcluster --stop 8.1 main
apt-get remove postgresql-8.1

No comments:

Post a Comment