Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:
Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux