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

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To:
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
Date: 2012-10-17 21:56:17
Message-ID: 1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

fantastic !
thanks.
greg

>________________________________
> From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
>To: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
>Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
>Sent: Wednesday, October 17, 2012 10:05 AM
>Subject: Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1
>
>On Wed, Oct 3, 2012 at 4:53 PM, Greg Williamson <gwilliamson39(at)yahoo(dot)com> wrote:
>>
>> 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.
>>
>
>Just in case, it seems like
>http://archives.postgresql.org/pgsql-committers/2012-10/msg00194.php
>is a fix to your problem. It was commited a few minutes ago by Tom
>Lane so you can patch your instalation or wait until the next
>postgresql minor version to be released
>
>--
>Jaime Casanova        www.2ndQuadrant.com
>Professional PostgreSQL: Soporte 24x7 y capacitación
>Phone: +593 4 5107566        Cell: +593 987171157
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shams Khan 2012-10-18 06:13:52 Migration from Postgresql 9 to Oracle 10g
Previous Message Parkirat Bagga 2012-10-17 21:21:28 Re: Streaming Replication (Master Delta Sync)