Postgres 9.1 to 9.2 upgrade guide for Ubuntu 12.04

gistfile1.sh

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install postgresql-9.2 postgresql-server-dev-9.2 postgresql-contrib-9.2

sudo su -l postgres
psql -d template1 -p 5433
CREATE EXTENSION IF NOT EXISTS hstore;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
service postgresql stop
/usr/lib/postgresql/9.2/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.2/bin -d /var/lib/postgresql/9.1/main/ -D /var/lib/postgresql/9.2/main/ -O "-c config_file=/etc/postgresql/9.2/main/postgresql.conf" -o "-c config_file=/etc/postgresql/9.1/main/postgresql.conf"

logout # logout postgresql back to previous user

sudo apt-get remove postgresql-9.1
sudo vim /etc/postgresql/9.2/main/postgresql.conf # change port to 5432
sudo service postgresql restart

👍

A bit easier way:

Add apt.postgresql.org repository by running this script: http://anonscm.debian.org/loggerhead/pkg-postgresql/postgresql-common/trunk/download/head:/apt.postgresql.org.s-20130224224205-px3qyst90b3xp8zj-1/apt.postgresql.org.sh

sudo apt-get install postgresql-9.2 postgresql-client-9.2 postgresql-contrib-9.2 postgresql-server-dev-9.2
su postgres
pg_ctlcluster 9.1 main stop
pg_ctlcluster 9.2 main stop
pg_dropcluster 9.2 main
pg_upgradecluster 9.1 main
pg_ctlcluster 9.2 main start
CTRL-D to quit su postgres
sudo apt-get remove postgresql-9.1

The gist worked fine to upgrade from 9.1 to postgresql 9.3!
Thanks a lot!

Awesome, thanks.

Thanks a lot! You saved my time!

I did it this way (for 9.3), in an automated fashion.

https://gist.github.com/ibussieres/11262268

Thanks @ibussieres. Upgraded to 9.3.

Perfect! Works like a charm.

Thanks!

Worked great...until I got to PostGIS. Check out this post for details on dealing with the simultaneous postgres 9.1->9.3, postgis 1.5->2.x upgrade: http://sorokine.blogspot.com/2013/11/upgrading-postgresql-91postgis-15-to.html

Thanks @ibussieres. It worked... Awesome

Instructions for upgrading from 9.3 to 9.4: https://gist.github.com/dideler/60c9ce184198666e5ab4