Upgrading from Pg 9.1 to 9.2

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 <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!

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

On Tue, Jul 16, 2013 at 5:20 PM, salah jubeh <s_jubeh@yahoo.com> wrote:

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

The manual pages doesn't talk about install Postgresql from Linux
repository for example it doens't mentioed what if I need to use
pg_upgrade for bin dir which located in complete different path than
Postgresql installer. So I'm lookinhg for specified steps not general
information because I don't want to damage my data

--
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

Hello,

There are many  ways to to upgrade postgres;  but, it is not on the fly process for major releases i.e 9.1 to 9.2, and you need to pick what suits you. Ubuntu is using debian packages and when you use it you  will have another instance with another point as you have mentioned.

What you need to do

1. either use pg_dumpall /pg_restore in order to load your data in postgresql or pgupgrade.
2. purge 9.1 version
3. reconfigure 9.2 to use port 5432 , ......

Also have a look here

http://wiki.postgresql.org/wiki/Using_pg_upgrade_on_Ubuntu/Debian

Regards

________________________________
From: Muhammad Bashir Al-Noimi <mbnoimi@gmail.com>
To: salah jubeh <s_jubeh@yahoo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Sent: Tuesday, July 16, 2013 5:50 PM
Subject: Re: [GENERAL] Upgrading from Pg 9.1 to 9.2

On Tue, Jul 16, 2013 at 5:20 PM, salah jubeh <s_jubeh@yahoo.com> wrote:

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

The manual pages doesn't talk about install Postgresql from Linux
repository for example it doens't mentioed what if I need to use
pg_upgrade for bin dir which located in complete different path than
Postgresql installer. So I'm lookinhg for specified steps not general
information because I don't want to damage my data

--
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

On Tue, Jul 16, 2013 at 11:52 PM, salah jubeh <s_jubeh@yahoo.com> wrote:

Also have a look here

http://wiki.postgresql.org/wiki/Using_pg_upgrade_on_Ubuntu/Debian

Thanks a lot, I could successfully upgrade my server

--
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