Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1

Gabriele --

----- Original Message -----
> From: Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndQuadrant(dot)it>
> To: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> Sent: Wednesday, October 3, 2012 4:41 AM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1
>
> Hi Greg,
>
> On Tue, 2 Oct 2012 15:02:23 -0700 (PDT), Greg Williamson
> <gwilliamson39(at)yahoo(dot)com> wrote:
>
>> Other than abandoning repmgr I don't see a solution. I've posted
> this
>> to the repmgr discussion group but have had zero responses (and,
>> frankly, am not holding my breath).
>
> If you are 100% sure it is repmgr ... :)
>
> I am not 100% sure it is ... Under normal circumstances (once the standby has
> been cloned), repmgr simply controls the status of a standby server
> communicating with a master through the streaming replication protocol. As any
> other standby would do.
>

Indeed -- stopping repmgr has lef to a continued accumulation of the dead but not gone file handles, but almost all are now owned by the application, with only a few held by WAL shipping and the like. So repmgr was just getting the blame, unfairly.

Am working on the code itself now.

Thanks for the response!

Greg W.