Hey all,
I am in the process of upgrading to Postgres 10, and am having trouble
getting my streaming replica working.
OS: Debian 9.2
Version: 10.1
I have my primary backed up using pgbackrest, and I restore that to my
replica. It generates a recovery.conf which has a restore command for
the WAL to pull them from the pgbackrest server.
The recovery succeeds, but when I go to start the cluster on the
standby, it begins to replay the WAL, and does so for about 30
seconds. Then I get a line in my log saying:
> pg_ctl: server did not start in time
Followed by:
> 2017-11-10 20:27:35.907 UTC [7132] LOG: received smart shutdown request
> ERROR [063]: : terminated on signal [SIGTERM]
> 2017-11-10 20:27:35.911 P00 INFO: archive-get command end: terminated on signal [SIGTERM]
ERROR [063]: : terminated on signal [SIGTERM]
> 2017-11-10 20:27:35.912 P00 INFO: archive-get command end: terminated on signal [SIGTERM]
> 2017-11-10 20:27:35.978 UTC [7142] LOG: shutting down
> 2017-11-10 20:27:36.151 UTC [7132] LOG: database system is shut down
This happens weather I have the server configured as a standby or not.
Any help would be very appreciated.
Thanks,
-Adam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general