Adrian Klaver <adrian.klaver@aklaver.com> writes: > On 7/23/19 7:17 AM, Perumal Raj wrote: >> 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.
Yeah, this is clearly a version-skew problem. pg_upgrade knows it should say unix_socket_directory not unix_socket_directories to a pre-9.3 server, but that's going wrong somehow.
> Are you sure that /usr/pgsql-9.2/bin/pg_ctl is really pointing to a 9.2 > binary?
For quite some time, Red Hat shipped versions of 9.2.x that were patched to understand unix_socket_directories not unix_socket_directory. I would be suspicious that the source server was one of those, except that the cited path doesn't match where the Red Hat RPMs put it.
