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
