Re: Streaming Replication and archiving

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming Replication and archiving
Date: 2010-01-20 21:33:25
Message-ID: 4B5776A5.4030909@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:
>> Thanks Dimitri, I'd missed that thread. Ok, slave will need a suitable
>> restore_comand in addition to primary_conninfo in recovery.conf, and
>> then extended communication failures (or shutting down the slave for a
>> while!) will not break the streaming setup (FWIW I tried this just now).
>>
>
> Sure, but if the archived WAL segments are NOT needed, how are they
> supposed to get deleted? It doesn't take long to run out of disk space
> if they're not being rotated.
>
>

+1

From what I am seeing at the moment (8.5 devel from 2 days ago), the
archived segments are not deleted at all (I have several hundred now
after a number of pgbench runs over the last day or so).

regards

Mark

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message James William Pye 2010-01-20 21:47:50 Re: [NOVICE] Python verison for build in config.pl (Win32)
Previous Message Peter Eisentraut 2010-01-20 21:17:42 Re: per-user pg_service.conf