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