Sorry i missed to refer link.
https://dba.stackexchange.com/questions/50135/pg-upgrade-unrecognized-configuration-parameter-unix-socket-directory
On Tue, Jul 23, 2019 at 9:20 AM Tom Lane wrote:
> Perumal Raj writes:
> > Finally upgrade completed successfully after implementing the following
>
Perumal Raj writes:
> Finally upgrade completed successfully after implementing the following
> Workaround.
You didn't say where you got these executables from, but if the 9.2 and 11
packages were from the same packager, you should complain to them about
it. If they're patching 9.2 to have unix_
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 ''Z
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 wrote:
> Adrian Klaver writ
Adrian Klaver 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
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 stopp
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
Exa
On Tue, Jul 23, 2019 at 3:56 PM Perumal Raj 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
Hi Team,
Please give me some pointers to resolve this issue.
-bash-4.2$ export OLDCLUSTER=/usr/pgsql-9.2
-bash-4.2$ export NEWCLUSTER=/usr/pgsql-11
-bash-4.2$ /usr/pgsql-11/bin/pg_upgrade --old-bindir=$OLDCLUSTER/bin
--new-bindir=$NEWCLUSTER/bin --old-datadir=/data/db/data
--new-datadir=/pgdata/
