From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Ashish Chauhan <Ashish(dot)Chauhan(at)support(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres upgrade from 9.4.9 to 9.6 using pg_upgrade error |
Date: | 2016-10-20 14:06:51 |
Message-ID: | 20161020140651.GA19020@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)momjian(dot)us> 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 +
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-10-20 14:09:35 | Re: configure PostgreSQL with the python: distutils module not found |
Previous Message | Tom Lane | 2016-10-20 14:03:42 | Re: configure PostgreSQL with the python: distutils module not found |