Re: [GENERAL] 9.2 to 9.5 pg_upgrade losing data

2016-08-17 Thread Pete Fuller
We first noticed the issue after running the generated analyze script, in subsequent tests it shows up before the analyze though. Ran thru the process as a test monday night and it worked. This time however, I deleted the complete 9.2 data directory before running our rsync scripts that refre

Re: [GENERAL] 9.2 to 9.5 pg_upgrade losing data

2016-08-15 Thread Pete Fuller
after a brainstorming session here. We are going to attempt another test this evening with all crons disabled and monitoring disabled. Pete Fuller, Tracking Server Systems Administrator 2055 North Brown Road, Suite 225, Lawrenceville, GA 30043 M: 678.677.5864 pete_ful...@3sisecurity.com

Re: [GENERAL] 9.2 to 9.5 pg_upgrade losing data

2016-08-15 Thread Pete Fuller
hardware and setup with same install scripts. > On Aug 15, 2016, at 10:55 AM, Adrian Klaver wrote: > > On 08/15/2016 07:40 AM, Pete Fuller wrote: >> Directories are correct. We do not utilize tablespaces. > > Anything obviously different in the setup between your producti

Re: [GENERAL] 9.2 to 9.5 pg_upgrade losing data

2016-08-15 Thread Pete Fuller
Directories are correct. We do not utilize tablespaces. > On Aug 15, 2016, at 10:06 AM, Adrian Klaver wrote: > > On 08/15/2016 06:20 AM, Pete Fuller wrote: >> Hello all, >> >> We are attempting to upgrade a production 9.2 postgres cluster to 9.5. The >>

[GENERAL] 9.2 to 9.5 pg_upgrade losing data

2016-08-15 Thread Pete Fuller
Hello all, We are attempting to upgrade a production 9.2 postgres cluster to 9.5. The server is running Centos 7 with the Centos version - currently 9.2.15 We are installing the postgresql provided rpm of postgresql9.5 from the postgresql repo, currently 9.5.4. In testing and on our development