| 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: | Whole Thread | Raw Message | 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 |