Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6

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(at)gmail(dot)com> wrote:

> On Tue, Jul 23, 2019 at 3:56 PM Perumal Raj <perucinci(at)gmail(dot)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
>