Re: [GENERAL] How to migrate from PGSQL 9.3 to 9.6

2016-11-30 Thread John R Pierce
On 11/30/2016 10:27 AM, Sinclair, Ian D (Ian) wrote: The actual upgrade will be that I have an existing server running 9.3 on RHEL 6.2. We’ll have to do a backup of the database, then deploy a new OVA to get to RHEL 7 with PG 9.6, then restore the database. Are there any specific steps that I

Re: [GENERAL] How to migrate from PGSQL 9.3 to 9.6

2016-11-30 Thread Adrian Klaver
On 11/30/2016 10:27 AM, Sinclair, Ian D (Ian) wrote: The actual upgrade will be that I have an existing server running 9.3 on RHEL 6.2. We’ll have to do a backup of the database, then deploy a new OVA to get to RHEL 7 with PG 9.6, then restore the database. Are there any specific steps that I’ll

Re: [GENERAL] How to migrate from PGSQL 9.3 to 9.6

2016-11-30 Thread Sinclair, Ian D (Ian)
answer above.) Thanks From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: November 29, 2016 5:47 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to migrate from PGSQL 9.3 to 9.6 On 11/29/2016 2:20 PM, Sinclair, Ian D

Re: [GENERAL] How to migrate from PGSQL 9.3 to 9.6

2016-11-29 Thread John R Pierce
On 11/29/2016 2:20 PM, Sinclair, Ian D (Ian) wrote: I’ve found the RPMS I need, but I’ve come across a setup file that I think I need to get a correct version of. I found references to postgresql-setup, but I have a feeling that I may need a version specific copy of that script. If I get the

[GENERAL] How to migrate from PGSQL 9.3 to 9.6

2016-11-29 Thread Sinclair, Ian D (Ian)
I've never worked with Postgres, but I've been tasked with upgrading our product from using 9.3 to 9.6. Please feel free to direct me to appropriate newbie docs. I've found the RPMS I need, but I've come across a setup file that I think I need to get a correct version of. I found references to