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

Поиск
Список
Период
Сортировка
От Greg Williamson
Тема Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
Дата
Msg-id 1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1  (Jaime Casanova <jaime@2ndquadrant.com>)
Список pgsql-admin
fantastic !
thanks.
greg


From: Jaime Casanova <jaime@2ndquadrant.com>
To: Greg Williamson <gwilliamson39@yahoo.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.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@yahoo.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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Parkirat Bagga
Дата:
Сообщение: Re: Streaming Replication (Master Delta Sync)
Следующее
От: Shams Khan
Дата:
Сообщение: Migration from Postgresql 9 to Oracle 10g