On Tue, Oct 18, 2016 at 10:15:47PM +0000, 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/ > 9.4/main/postgresql.conf -c config_file=/etc/postgresql/9.6/main/ > postgresql.conf -c listen_addresses='' -c unix_socket_permissions=0700 -c > unix_socket_directories='/tmp'" start >> "pg_upgrade_server.log" 2>&1 > > waiting for server to start....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 version 9.4.9. > > stopped waiting > > pg_ctl: could not start server > > Examine the log output. > > > > Is it possible to upgrade Postgres 9.4.9 to 9.6 with pg_upgrade option or I > need to do it through pg_dump only? Any help would be appreciated. It should work. I think you haven't follow the cluster initialization instructions properly and installed the wrong version somewhere. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
