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 <mbnoimi@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!
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general