Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghWii-0006qS-FT for pgsql-admin@arkaria.postgresql.org; Thu, 10 Jan 2019 09:33:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghWih-0008Mf-4p for pgsql-admin@arkaria.postgresql.org; Thu, 10 Jan 2019 09:33:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghWig-0008MY-Pd for pgsql-admin@lists.postgresql.org; Thu, 10 Jan 2019 09:33:46 +0000 Received: from sdcsmtp.sdc-world.com ([24.153.34.136]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghWie-000217-2C for pgsql-admin@lists.postgresql.org; Thu, 10 Jan 2019 09:33:45 +0000 X-ASG-Debug-ID: 1547112821-1075dd16e6576fd0001-e2Aq3s Received: from sdcsrvex01.sdc-world.com ([192.168.11.133]) by sdcsmtp.sdc-world.com with ESMTP id iBIblVPcPVs6j5l8 (version=TLSv1 cipher=AES128-SHA bits=128 verify=NO) for ; Thu, 10 Jan 2019 04:33:41 -0500 (EST) X-Barracuda-Envelope-From: denise.ferrell@sdc-world.com X-ASG-Whitelist: Client Received: from SDCX.sdc-world.com (192.168.11.131) by SDCSRVEX01.sdc-world.com (192.168.11.133) with Microsoft SMTP Server (TLS) id 8.3.485.1; Thu, 10 Jan 2019 04:33:41 -0500 Received: from SDCX.sdc-world.com (192.168.11.131) by SDCX.sdc-world.com (192.168.11.131) with Microsoft SMTP Server (TLS) id 15.0.1347.2; Thu, 10 Jan 2019 04:33:41 -0500 Received: from SDCX.sdc-world.com ([::1]) by SDCX.sdc-world.com ([::1]) with mapi id 15.00.1347.000; Thu, 10 Jan 2019 04:33:41 -0500 From: "Ferrell, Denise SDC" To: "pgsql-admin@lists.postgresql.org" Subject: Upgrade Moving Data Thread-Topic: Upgrade Moving Data X-ASG-Orig-Subj: Upgrade Moving Data Thread-Index: AQHUqMcQNzgfPoBjz0a0+pogqPC9IA== Date: Thu, 10 Jan 2019 09:33:40 +0000 Message-ID: <1547112819972.34953@sdc-world.com> References: <80E28CE6-DCE0-4E66-8B50-EFF65923E7DD@gmail.com>, In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [158.112.85.66] Content-Type: multipart/alternative; boundary="_000_154711281997234953sdcworldcom_" MIME-Version: 1.0 X-Barracuda-Connect: UNKNOWN[192.168.11.133] X-Barracuda-Start-Time: 1547112821 X-Barracuda-Encrypted: AES128-SHA X-Barracuda-URL: https://192.168.11.136:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at sdc-world.com X-Barracuda-Scan-Msg-Size: 1115 X-Barracuda-BRTS-Status: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_154711281997234953sdcworldcom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Upgrading from RHEL5 Postgres v.9.5 to RHEL7 v10.3 on VMs. While the database objects have been created on the new VM I'm having issue= s getting the data moved over. I've tried a data only pg dump and restore = it fails. Any ideas as to how to accomplish this Thank you in advance for any assistance, Denise --_000_154711281997234953sdcworldcom_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Upgrading from RHEL5 Postgres v.9.5 to RHEL7 v10.3 on VMs.


While the database objects have been created on the new VM I'm havi= ng issues getting the data moved over.  I've tried a data only pg dump= and restore it fails.


Any ideas as to how to accomplish this


Thank you in advance for any assistance,

Denise

--_000_154711281997234953sdcworldcom_--