On 08/16/2017 02:41 PM, Alex Samad wrote: (...) > > okay think I have it setup, but when i do a switch over it gets stuck here. > > > > NOTICE: STANDBY PROMOTE successful > NOTICE: Executing pg_rewind on old master server > NOTICE: 3 files copied to /var/lib/pgsql/9.6/data > NOTICE: restarting server using '/usr/pgsql-9.6/bin/pg_ctl -w -D /var/lib/pgsql/9.6/data -m fast restart' > pg_ctl: PID file "/var/lib/pgsql/9.6/data/postmaster.pid" does not exist > Is server running? > starting server anyway > NOTICE: STANDBY FOLLOW successful
From the repmgr README:
>> You must ensure that following a server start using `pg_ctl`, log output >> is not send to STDERR (the default behaviour). If logging is not configured, >> we recommend setting `logging_collector=on` in `postgresql.conf` and >> providing an explicit `-l/--log` setting in `repmgr.conf`'s `pg_ctl_options` >> parameter.
i.e. when the old primary is restarted with:
/usr/pgsql-9.6/bin/pg_ctl -w -D /var/lib/pgsql/9.6/data -m fast restart
the calling process hangs, waiting for logging output from pg_ctl. In "repmgr.conf" set "pg_ctl_options" to something like:
pg_ctl_options='-l /path/to/log'
Regards
Thanks, simple when you know, too many new things to look at
