From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: how to upgrade from 8.4 to 9.2
Date: Wed, 30 Nov 2016 09:32:28 +0200
Message-ID: <583E808C.4090800@matrix.gatewaynet.com> (raw)
In-Reply-To: <CY1PR0201MB1436755FA94C8F50B1CC60ED9D8D0@CY1PR0201MB1436.namprd02.prod.outlook.com>
References: <CY1PR0201MB1436755FA94C8F50B1CC60ED9D8D0@CY1PR0201MB1436.namprd02.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 29/11/2016 17:57, Marc Fromm wrote:
>
> To be compatible with my live server I need to upgrade postgresql v8.4 running on a CentOS6.4 server to postgresql v9.2. Is there a step by step procedure on this so that I properly remove 8.4,
> install 9.2 and have it work with PHP? Will CentOS6.4 support the newer version of postgreslq with yum updates or do I have to upgrade to CentOS7?
>
I'd say look at pg_upgrade and also make a lot of tests. Plan and test your final upgrade.
I have no experience with CentOS, I never use package managers for PostgreSQL, always compile from source.
The idea is to have the old binaries and the new binaries and then perform pg_upgrade. Pg_upgrade will guide you through.
> I already downloaded pgdg-centos92-9.2-8.noarch.rpm for CentOS6.4 from https://yum.postgresql.org/repopackages.php#pg92.
>
> Thanks
>
> Marc
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com
Subject: Re: how to upgrade from 8.4 to 9.2
In-Reply-To: <583E808C.4090800@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox