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

Hi All,

Finally upgrade completed successfully after implementing the following
Workaround.

mv /usr/bin/pg_ctl{,-orig}
echo '#!/bin/bash' > /usr/bin/pg_ctl
echo '"$0"-orig "${@/unix_socket_directory/unix_socket_directories}"' >>
/usr/bin/pg_ctl
chmod +x /usr/bin/pg_ctl
*Special thanks to ''Ziggy Crueltyfree Zeitgeister '*

On Tue, Jul 23, 2019 at 7:51 AM Perumal Raj <perucinci(at)gmail(dot)com> wrote:

> 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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
>>
>