Skip to content

Instantly share code, notes, and snippets.

@ivanvanderbyl
Created December 6, 2012 06:55
Show Gist options
  • Star 92 You must be signed in to star a gist
  • Fork 33 You must be signed in to fork a gist
  • Save ivanvanderbyl/4222308 to your computer and use it in GitHub Desktop.
Save ivanvanderbyl/4222308 to your computer and use it in GitHub Desktop.
Postgres 9.1 to 9.2 upgrade guide for Ubuntu 12.04
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
@shark300
Copy link

Thank you!

@guivinicius
Copy link

Great. Thank you!

@jwarzech
Copy link

Thanks!

@mbnoimi
Copy link

mbnoimi commented Jul 16, 2013

This line doesn’t work

CREATE EXTENSION IF NOT EXISTS hstore;

It gives this error message:

template1=# CREATE EXTENSION IF NOT EXISTS hstore;
ERROR:  could not open extension control file "/usr/share/postgresql/9.2/extension/hstore.control": No such file or directory
template1=#

@frootloops
Copy link

Thank you!

@barakargaman
Copy link

thanks!

@hunterowens
Copy link

This no longer work on 12.04 LTS.

E: Package 'postgresql-9.2' has no installation candidate

@AiOO
Copy link

AiOO commented Sep 6, 2013

This worked fine on ubuntu 12.04 :)

@kivikakk
Copy link

Worked well for upgrading 9.0 to 9.3, too.

@revathskumar
Copy link

Can any one explain me the what line no. 10 do?

@as181920
Copy link

worked well for upgrading 9.1 to 9.3 on ubuntu server 12.04 LTS
Thanks a lot

@ntucker
Copy link

ntucker commented Sep 25, 2013

How do I get 9.3?

@montogeek
Copy link

Very much thanks Sir!

@nonintanon
Copy link

Thank you :)

@scarver2
Copy link

scarver2 commented Dec 5, 2013

Worked great for upgrading 9.2 -> 9.3 also

@ntucker Follow these directions to upgrade PostgreSQL 9.3 on Ubuntu http://wiki.postgresql.org/wiki/Apt

@petere
Copy link

petere commented Dec 12, 2013

You should be looking into using pg_upgradecluster. It's much easier than this.

@pecha7x
Copy link

pecha7x commented Jan 14, 2014

Worked perfect for 9.1 -> 9.3
Thanks!

@simeonwillbanks
Copy link

👍

@mleszcz
Copy link

mleszcz commented Feb 12, 2014

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

@Kulgar
Copy link

Kulgar commented Feb 24, 2014

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

@bernardeli
Copy link

Awesome, thanks.

@curpeng
Copy link

curpeng commented Apr 1, 2014

Thanks a lot! You saved my time!

@ibussieres
Copy link

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

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

@borgesalkan
Copy link

Thanks @ibussieres. Upgraded to 9.3.

@lukaszbudnik
Copy link

Perfect! Works like a charm.

@syadlowsky
Copy link

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

@railsfactory-kumaresan
Copy link

Thanks @ibussieres. It worked... Awesome

@dideler
Copy link

dideler commented Nov 2, 2014

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment