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

On 7/23/19 7:17 AM, Perumal Raj wrote:
> 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"

Well unix_socket_directory changed to  unix_socket_directories in 9.3.

Are you sure that /usr/pgsql-9.2/bin/pg_ctl is really pointing to a 9.2 
binary?

>   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 
> <mailto:fluca1978@gmail.com>> wrote:
> 
>     On Tue, Jul 23, 2019 at 3:56 PM Perumal Raj <perucinci@gmail.com
>     <mailto: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
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com