DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=eE73ibpO11AZ1kbgjlN+doxI4X3DJMeO4hdG2Gtu+8eafg9/qFUunO3mFhxw0it6I/2CXAlx3N8lJy1FZ0DNQXYt9LU7O/++0VdgQnhC1DPGImMzX3s5ZSElfzH4wCiwjZkpvOp+gib9Zkdr/ANlswqp8gaw7Usa1VI0j3O664Q=;
References: <1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com>
	<5064D7BC.1000709@pinpointresearch.com>
	<1348797684.2846.YahooMailNeo@web125904.mail.ne1.yahoo.com>
	<10417.1348798479@sss.pgh.pa.us>
	<1348799034.68119.YahooMailNeo@web125902.mail.ne1.yahoo.com>
	<1349215343.78143.YahooMailNeo@web125901.mail.ne1.yahoo.com>
	<e7aa07eea185c183fa4de08d71547a58@2ndquadrant.it>
Message-ID: <1349301231.12551.YahooMailNeo@web125905.mail.ne1.yahoo.com>
Date: Wed, 3 Oct 2012 14:53:51 -0700 (PDT)
From: Greg Williamson <gwilliamson39@yahoo.com>
Reply-To: Greg Williamson <gwilliamson39@yahoo.com>
Subject: Re: Database size stays constant but disk space keeps shrinking --
	postgres 9.1
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <e7aa07eea185c183fa4de08d71547a58@2ndquadrant.it>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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 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.