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

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Gabriele Bartolini <Gabriele(dot)Bartolini(at)2ndquadrant(dot)it>
Cc: Greg Williamson <gwilliamson39(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
Date: 2012-10-03 13:56:17
Message-ID: CAJKUy5juz8AEZoo24sW4NoURwvp=nr-_WjTyb3hmxNQdSKC=aQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Oct 3, 2012 at 6:41 AM, Gabriele Bartolini
<Gabriele(dot)Bartolini(at)2ndquadrant(dot)it> wrote:
> Hi Greg,
>
>
> On Tue, 2 Oct 2012 15:02:23 -0700 (PDT), Greg Williamson
> <gwilliamson39(at)yahoo(dot)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.
>

more to the point...
if this is happening on master (where you can create and drop
databases), then repmgrd has no reason to be running there... and very
limited subset of commands (master register, cluster show, cluster
cleanup) can be run on master

--
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 Scott Whitney 2012-10-03 16:55:43 Migrating to PG 9.2 (LONG, SORRY)
Previous Message Gabriele Bartolini 2012-10-03 11:41:32 Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1