Hi All, Yes, , bin file correct only as it came up with CentOS 7.6 .
Anyhow , thanks for the pointers which helped me to look at hacking solution :-) Currently , upgrade is running. will keep u posted with results. Thanks, On Tue, Jul 23, 2019 at 7:43 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > Adrian Klaver <adrian.kla...@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. > > regards, tom lane >
