Re: [GENERAL] Postgres upgrade from 9.4.9 to 9.6 using pg_upgrade error

2016-10-21 Thread wd
On Wed, Oct 19, 2016 at 6:15 AM, Ashish Chauhan wrote: > *2016-10-18 22:11:30 UTC [13107-1] FATAL: database files are incompatible > with server* > > *2016-10-18 22:11:30 UTC [13107-2] DETAIL: The data directory was > initialized by PostgreSQL version 9.6, which is not compatible with this > ve

Re: [GENERAL] Postgres upgrade from 9.4.9 to 9.6 using pg_upgrade error

2016-10-20 Thread Bruce Momjian
On Tue, Oct 18, 2016 at 10:15:47PM +, Ashish Chauhan wrote: > ยท I am getting below error while executing above command: > > command: "/usr/lib/postgresql/9.4/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D > "/var/lib/postgresql/9.4/main" -o "-p 50432 -b -c config_file=/etc/postgresql/ >

[GENERAL] Postgres upgrade from 9.4.9 to 9.6 using pg_upgrade error

2016-10-20 Thread Ashish Chauhan
Hi, I am planning to upgrade our current Postgres 9.4.9 to 9.6 version using pg_upgrade method to reduce Production downtime. I followed below steps so far, * Postgres 9.4.9 running on 5432 port. * Same server, installed Postgres 9.6, its running fine on 5433 port. * S