Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cBzPO-000558-Ke for pgsql-admin@arkaria.postgresql.org; Wed, 30 Nov 2016 07:34:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cBzPN-0008H3-M1 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Nov 2016 07:34:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cBzNf-0006MZ-2U for pgsql-admin@postgresql.org; Wed, 30 Nov 2016 07:32:39 +0000 Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=smadev.internal.net) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cBzNb-0004jH-Mv for pgsql-admin@postgresql.org; Wed, 30 Nov 2016 07:32:37 +0000 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id uAU7WSK1098693 for ; Wed, 30 Nov 2016 09:32:30 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: how to upgrade from 8.4 to 9.2 To: pgsql-admin@postgresql.org References: From: Achilleas Mantzios Message-ID: <583E808C.4090800@matrix.gatewaynet.com> Date: Wed, 30 Nov 2016 09:32:28 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------000500060403060904020108" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------000500060403060904020108 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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 --------------000500060403060904020108 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

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

--------------000500060403060904020108--