Date: Tue, 2 Jul 2019 17:05:17 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Mark Steben <mark.steben@drivedominion.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_xlog no longer rotating out
Message-ID: <20190702210517.GA30568@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CADyzmyxDTSwcRhRTnMGKdQYsxg7N_Sw2avUizkaxwdKZwOhs0A@mail.gmail.com>
User-Agent: Mutt/1.9.4 (2018-02-28)
Precedence: bulk

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