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 |
This comment has been minimized.
This comment has been minimized.
Thanks it worked perfectly fine! |
This comment has been minimized.
This comment has been minimized.
Flawless! Thank you! |
This comment has been minimized.
This comment has been minimized.
Thank you! |
This comment has been minimized.
This comment has been minimized.
Great. Thank you! |
This comment has been minimized.
This comment has been minimized.
Thanks! |
This comment has been minimized.
This comment has been minimized.
This line doesn’t work
It gives this error message:
|
This comment has been minimized.
This comment has been minimized.
Thank you! |
This comment has been minimized.
This comment has been minimized.
thanks! |
This comment has been minimized.
This comment has been minimized.
This no longer work on 12.04 LTS.
|
This comment has been minimized.
This comment has been minimized.
This worked fine on ubuntu 12.04 :) |
This comment has been minimized.
This comment has been minimized.
Worked well for upgrading 9.0 to 9.3, too. |
This comment has been minimized.
This comment has been minimized.
Can any one explain me the what line no. 10 do? |
This comment has been minimized.
This comment has been minimized.
worked well for upgrading 9.1 to 9.3 on ubuntu server 12.04 LTS |
This comment has been minimized.
This comment has been minimized.
How do I get 9.3? |
This comment has been minimized.
This comment has been minimized.
Very much thanks Sir! |
This comment has been minimized.
This comment has been minimized.
Thank you :) |
This comment has been minimized.
This comment has been minimized.
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 |
This comment has been minimized.
This comment has been minimized.
You should be looking into using |
This comment has been minimized.
This comment has been minimized.
Worked perfect for 9.1 -> 9.3 |
This comment has been minimized.
This comment has been minimized.
|
This comment has been minimized.
This comment has been minimized.
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 |
This comment has been minimized.
This comment has been minimized.
The gist worked fine to upgrade from 9.1 to postgresql 9.3! |
This comment has been minimized.
This comment has been minimized.
Awesome, thanks. |
This comment has been minimized.
This comment has been minimized.
Thanks a lot! You saved my time! |
This comment has been minimized.
This comment has been minimized.
I did it this way (for 9.3), in an automated fashion. |
This comment has been minimized.
This comment has been minimized.
Thanks @ibussieres. Upgraded to 9.3. |
This comment has been minimized.
This comment has been minimized.
Perfect! Works like a charm. |
This comment has been minimized.
This comment has been minimized.
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 |
This comment has been minimized.
This comment has been minimized.
Thanks @ibussieres. It worked... Awesome |
This comment has been minimized.
This comment has been minimized.
Instructions for upgrading from 9.3 to 9.4: https://gist.github.com/dideler/60c9ce184198666e5ab4 |
This comment has been minimized.
This is perfect. Worked without any hiccups on production. Thanks!