Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgxfg-0000Ee-EQ for pgsql-admin@arkaria.postgresql.org; Thu, 23 Feb 2017 17:59:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cgxff-00080X-Td for pgsql-admin@arkaria.postgresql.org; Thu, 23 Feb 2017 17:59:15 +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 1cgxdx-0004OU-9o for pgsql-admin@postgresql.org; Thu, 23 Feb 2017 17:57:29 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgxdq-0004B7-EJ for pgsql-admin@postgresql.org; Thu, 23 Feb 2017 17:57:28 +0000 Received: from mail.etecsa.cu (unknown [192.168.91.10]) by imx6.etecsa.cu (Postfix) with ESMTP id 50493116 for ; Thu, 23 Feb 2017 12:57:06 -0500 (CST) Received: from webmail.etecsa.cu (webmail.etecsa.cu [192.168.91.6]) by mail.etecsa.cu (Postfix) with ESMTP id 2FC183000073; Thu, 23 Feb 2017 12:57:06 -0500 (CST) Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Thu, 23 Feb 2017 12:57:06 -0500 (GMT+5) Message-ID: <44804.192.168.207.54.1487872626.squirrel@webmail.etecsa.cu> In-Reply-To: <58AF1E37.90309@nrc-cnrc.gc.ca> References: <58AF1E37.90309@nrc-cnrc.gc.ca> Date: Thu, 23 Feb 2017 12:57:06 -0500 (GMT+5) Subject: Re: upgrade path from PG 8.3 to PG 9.5 From: "Gilberto Castillo" To: "ghiureai" Cc: "pgsql-admin@postgresql.org" Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 109629 [Feb 23 2017] X-KLMS-AntiSpam-Version: 5.7.0.14 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 178 178 787f2dae66e38c5ed519bcad5c0b5b61e0d5fb8c, {msgid_created_by_recepient}, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2017/02/22 09:07:41 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2017/02/23 06:53:00 #9114306 X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -2.6 (--) 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 > Hi List, > we still have 2 hosts running the old PG 8.3 version, we finally > agreed to move to PG9.5, please advise what will be the process for > this upgrade ? the db size for upgrade is 500GB( with 4 table spaces > on # volumes) > ( do I need to move first to PG9.0 and next move up?) > Isabella > No, you need. Use pgupgrade > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Saludos, Gilberto Castillo ETECSA, La Habana, Cuba -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin