Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TObbG-0001AV-B2 for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 21:56:26 +0000 Received: from nm2-vm3.bullet.mail.ne1.yahoo.com ([98.138.91.132]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TObb9-0003nU-Qa for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 21:56:25 +0000 Received: from [98.138.90.51] by nm2.bullet.mail.ne1.yahoo.com with NNFMP; 17 Oct 2012 21:56:17 -0000 Received: from [98.138.89.161] by tm4.bullet.mail.ne1.yahoo.com with NNFMP; 17 Oct 2012 21:56:17 -0000 Received: from [127.0.0.1] by omp1017.mail.ne1.yahoo.com with NNFMP; 17 Oct 2012 21:56:17 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 111218.54640.bm@omp1017.mail.ne1.yahoo.com Received: (qmail 50955 invoked by uid 60001); 17 Oct 2012 21:56:17 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1350510977; bh=3omFXj7oh7zl2WqNWMGc0Qbii9AztG/9k37E4RQBjt4=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type; b=P45pqrj3wiNKb0tecKJFjAqt6CazI+WzIrLXggnzs5EWsTtoy7bFtGjJUIBq+WDWGAn+E+b5bMuWEPJb2/J0MRyJ+sJ7F4HCf3jdfR1eYl0bv1sHerC7dEQ7Xye26ZiREuUGUAWxpYwWUbaCCA4/3SDzPcu9hJd8DcCaxkRjk4s= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type; b=M21kqOkeuY23q513JPJb2FfHkD4JpruLBzfVonxrjqwlP/prYqv3kGEBkRUjg8CCuwLVrQ5suphrMwkm5tnuGBy+ke7GzoY7Rg+U1zGMLlCNHzIlr+zuRCNHl3vfyF12u8pcSYXRE32KObkpQlXPn4Y6IzaRVRLjAkXWfyAPyRU=; X-YMail-OSG: EfAowCIVM1nwI2NOo5jIK6PljCkyJj0B2K6Fm9FxJQdFnH1 ee0Xw.LKvHuiMm25KO3OipRu0mEKXWrBYREvmYhpG67HmSm0Q2PbRfNAdlHK 9CxQ8tFn0oGDgtHrTS6wc2TQIkVaDzzyTQL3vX6UEYZ83yZ1JXm0t8mHs3Al 3TeQ_1Z85eNc.wPsolFiYyfJo2Cy6w0iZh9wE9wtVpOcc8FgeNb0DnRxnq6j EJnaVdrX1Mjess.ZhBwXIWtwefvwePjl5lF0J3Civz.bqi2VMNqbK_gHBnod pevp.wu3YaOq5yGwTxXPoBXZpFyejXIjfGwnyTFLfYSdPdvBqUqFzut2Y6bm myOTBNse5I_E29nNWqY79u.km3J3jt6SiFT2M0LiNu9DycH86_yzFrlezYqi dRaU5AzmW.8qJIKbuhyeJZzgNh3Y7gFT_C6gjhXVNfte8_oyFuCt9V6gkwpe ytpyw_9R78RfIegu6x0__bC7a_dET2TVBcFICjoQjNj3ADdm7w.EodeF8TBp fwYIYkDlZOOMum9eO1Nh6dbUYvQSqacUjDTVNsTYk8wQoB9cuQjwa0U04sw- - Received: from [98.210.146.78] by web125906.mail.ne1.yahoo.com via HTTP; Wed, 17 Oct 2012 14:56:17 PDT X-Rocket-MIMEInfo: 001.001, ZmFudGFzdGljICEKdGhhbmtzLgpncmVnCgoKCgoKPl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gRnJvbTogSmFpbWUgQ2FzYW5vdmEgPGphaW1lQDJuZHF1YWRyYW50LmNvbT4KPlRvOiBHcmVnIFdpbGxpYW1zb24gPGd3aWxsaWFtc29uMzlAeWFob28uY29tPiAKPkNjOiAicGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmciIDxwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZz4gCj5TZW50OiBXZWRuZXNkYXksIE9jdG9iZXIgMTcsIDIwMTIgMTA6MDUgQU0KPlN1YmplY3Q6IFJlOiBbQURNSU5dIEQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.123.450 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> <1349301231.12551.YahooMailNeo@web125905.mail.ne1.yahoo.com> Message-ID: <1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com> Date: Wed, 17 Oct 2012 14:56:17 -0700 (PDT) From: Greg Williamson Reply-To: Greg Williamson Subject: Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1 Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="452707994-1689528726-1350510977=:4726" X-Pg-Spam-Score: -0.8 (/) X-Archive-Number: 201210/68 X-Sequence-Number: 40184 --452707994-1689528726-1350510977=:4726 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable fantastic !=0Athanks.=0Agreg=0A=0A=0A=0A=0A=0A>____________________________= ____=0A> From: Jaime Casanova =0A>To: Greg Williamso= n =0A>Cc: "pgsql-admin@postgresql.org" =0A>Sent: Wednesday, October 17, 2012 10:05 AM=0A>Subjec= t: Re: [ADMIN] Database size stays constant but disk space keeps shrinking = -- postgres 9.1=0A> =0A>On Wed, Oct 3, 2012 at 4:53 PM, Greg Williamson wrote:=0A>>=0A>> Indeed -- stopping repmgr has lef t= o a continued accumulation of the dead but not gone file handles, but almos= t all are now owned by the application, with only a few held by WAL shippin= g and the like. So repmgr was just getting the blame, unfairly.=0A>>=0A>> A= m working on the code itself now.=0A>>=0A>=0A>Just in case, it seems like= =0A>http://archives.postgresql.org/pgsql-committers/2012-10/msg00194.php=0A= >is a fix to your problem. It was commited a few minutes ago by Tom=0A>Lane= so you can patch your instalation or wait until the next=0A>postgresql min= or version to be released=0A>=0A>-- =0A>Jaime Casanova=A0 =A0 =A0 =A0 www.= 2ndQuadrant.com=0A>Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n= =0A>Phone: +593 4 5107566=A0 =A0 =A0 =A0 Cell: +593 987171157=0A>=0A>=0A> --452707994-1689528726-1350510977=:4726 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
fantastic !
thanks.
greg

From: Jaime Casanova <jaime@2ndquadran= t.com>
To: Greg Williamson <g= williamson39@yahoo.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org> Sent: Wednesday, Octobe= r 17, 2012 10:05 AM
Subject: Re: [ADMIN] Database size stays constant but disk space keeps shrink= ing -- postgres 9.1

On Wed, Oct 3, 2012 at 4:53 PM, = Greg Williamson <gwilliamson39@yahoo.com> wrote:
&g= t;
> 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 ap= plication, with only a few held by WAL shipping and the like. So repmgr was= just getting the blame, unfairly.
>
> Am working on the code i= tself now.
>

Just in case, it seems like
http://archives.postgresql.org/pgsql-committers/2012-10/msg00194.phpis a fix to your problem. It was commited a few minutes ago by Tom
Lan= e so you can patch your instalation or wait until the next
postgresql mi= nor version to be released

--
Jaime Casanova     =   www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y cap= acitaci=F3n
Phone: +593 4 5107566        Cell: +593= 987171157


--452707994-1689528726-1350510977=:4726--