On 05/22/2017 01:15 AM, Dylan Luong wrote:
Hi
I have setup a master/standby on PostgreSQL95 on two test servers and
trialing out repmgr. (https://github.com/2ndQuadrant/repmgr/)
I am testing a switchover using the following:
-bash-4.1$ repmgr -f /etc/repmgr/9.5/repmgr.conf -C
/etc/repmgr/9.5/repmgr.conf standby switchover -L DEBUG -v
The switchover appears to hang at the last part of the switchover process….
/NOTICE: restarting server using '/usr/pgsql-9.5/bin/pg_ctl -w -D
/var/lib/pgsql/9.5/data -m fast restart'/
/pg_ctl: PID file "/var/lib/pgsql/9.5/data/postmaster.pid" does not exist/
/Is server running?/
/starting server anyway/
It appears to have worked though as when I run the cluster show command
on both servers it showing the switchover.
/-bash-4.1$ repmgr -f /etc/repmgr/9.5/repmgr.conf cluster show/
/Role | Name | Upstream | Connection String/
/----------+----------------|----------------|-------------------------------------------/
/* master | itupl-postgen2 | | host=10.70.3.252
dbname=repmgr user=repmgr/
/ standby | itupl-postgen1 | itupl-postgen2 | host=10.70.3.251
dbname=repmgr user=repmgr/
It is also showing correctly in repl_nodes table of the two databases.
Why is it hanging?? Thank you for your help…
You are using -w
https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html
"-w
Wait for the startup or shutdown to complete. Waiting is the
default option for shutdowns, but not startups. When waiting for
startup, pg_ctl repeatedly attempts to connect to the server. When
waiting for shutdown, pg_ctl waits for the server to remove its PID
file. This option allows the entry of an SSL passphrase on startup.
pg_ctl returns an exit code based on the success of the startup or shutdown.
"
So pg_ctl was trying to connect the server and did not find it at first:
"pg_ctl: PID file "/var/lib/pgsql/9.5/data/postmaster.pid" does not
exist. Is server running?"
but continued with the process:
"starting server anyway"
FYI in Postgres 10+ -w is the default for pg_ctl.
Here is the complete output:
/----------------------------------------------- /
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
