Hello, Have a look on http://www.postgresql.org/docs/9.1/static/upgrading.html and http://www.postgresql.org/docs/9.1/static/pgupgrade.html
Regards ________________________________ From: Muhammad Bashir Al-Noimi <mbno...@gmail.com> To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Sent: Tuesday, July 16, 2013 5:08 PM Subject: [GENERAL] Upgrading from Pg 9.1 to 9.2 Howdy, I want to upgrade my Postgresql server from 9.1 to 9.2 on ubuntu 12.04 but when I did the following ubuntu created a new server (on new port) instead of upgrading Postgresql & migrating the old data! sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgresql-9.2 sudo apt-get upgrade Is there any specified steps I've to do? -- Best Regards Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general