Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6 - Mailing list pgsql-general

From Perumal Raj
Subject Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6
Date
Msg-id CALvqh4r92NGA56JkWW-dvYFfTUOzZxv2g4WrBQAs2X7yCJ=h5g@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6  (Luca Ferrari <fluca1978@gmail.com>)
Responses Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi Luca

-bash-4.2$ "/usr/pgsql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
-bash-4.2$

-bash-4.2$ pwd
/var/lib/pgsql
-bash-4.2$ 

upgrade log :


command: "/usr/pgsql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start >> "pg_upgrade_server.log" 2>&1
waiting for server to start....FATAL:  unrecognized configuration parameter "unix_socket_directory"
 stopped waiting
pg_ctl: could not start server
Examine the log output.


On Tue, Jul 23, 2019 at 7:15 AM Luca Ferrari <fluca1978@gmail.com> wrote:
On Tue, Jul 23, 2019 at 3:56 PM Perumal Raj <perucinci@gmail.com> wrote:
> could not connect to source postmaster started with the command:
> "/usr/pgsql-9.2/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/data/db/data" -o "-p 5432 -b  -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" start
> Failure, exiting

Is /var/lib/pgsql directory on the system?
Can you start the instance with the above command?


Luca

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6
Next
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6