On 2019-Jul-02, Mark Steben wrote:
> Good afternoon,
> We run postgres 9.4 with hot standby streaming replication. We have been
> running abnormally high updates and the pg_xlogs have queued to about 80
> percent of disk capacity. This often happens and the network is not fast
> enough to handle the transfer of logs to the replicated server.
> What I have done in the past, and done again today is to change the
> archive_command from the script that scp's the logs to '/bin/true'. This
> stops the logship and allows the normal pg_xlog rotation to catch up.
Did you "pg_ctl reload" after changing the config file?
Maybe you have an inactive (or otherwise not advancing) replication
slot?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services