From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_xlog no longer rotating out |
Date: | 2019-07-02 21:05:17 |
Message-ID: | 20190702210517.GA30568@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Johannes Truschnigg | 2019-07-02 21:09:24 | Re: pg_xlog no longer rotating out |
Previous Message | Mark Steben | 2019-07-02 20:30:25 | pg_xlog no longer rotating out |