Postgres Pro
Downloads
Home   >   mailing lists

Thread: Upgrading from Pg 9.1 to 9.2

Upgrading from Pg 9.1 to 9.2

From
Muhammad Bashir Al-Noimi
Date:
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

Re: Upgrading from Pg 9.1 to 9.2

From
salah jubeh
Date:
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


Re: Upgrading from Pg 9.1 to 9.2

From
Muhammad Bashir Al-Noimi
Date:
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

Re: Upgrading from Pg 9.1 to 9.2

From
salah jubeh
Date:
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


Re: Upgrading from Pg 9.1 to 9.2

From
Muhammad Bashir Al-Noimi
Date:
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