Upgrading Postgres

Jurjen Bokma

November 2012


While migrating from Debian Squeeze to Debian Wheezy...

  1. sudo apt-get install postgresql-9.1

  2. (It's not serving anything yet.)

    sudo -u postgres pg_ctlcluster 9.1 main stop

  3. sudo -u postgres pg_dropcluster 9.1 main

  4. NB the order of the versions in the command:

    sudo -u postgres  pg_upgradecluster -v 9.1 8.4 main

  5. sudo -u postgres pg_dropcluster 8.4 main

  6. sudo apt-get remove -s postgresql-8.4