Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 - Mailing list pgsql-admin

From Greg Williamson
Subject Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
Date
Msg-id 1349301231.12551.YahooMailNeo@web125905.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1  (Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>)
Responses Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
List pgsql-admin
Gabriele --


----- Original Message -----
> From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
> To: Greg Williamson <gwilliamson39@yahoo.com>
> Cc: pgsql-admin@postgresql.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@yahoo.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
nowowned 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.


pgsql-admin by date:

Previous
From: Brian Fehrle
Date:
Subject: Re: Should data directories match between master and hot standby?
Next
From: Stephen Frost
Date:
Subject: Re: Migrating to PG 9.2 (LONG, SORRY)