Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming Replication and archiving - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Streaming Replication and archiving
Date
Msg-id 22807.1264029721@sss.pgh.pa.us
Whole thread Raw
In response to Re: Streaming Replication and archiving  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: Streaming Replication and archiving  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Re: Streaming Replication and archiving  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
Mark Kirkwood <mark.kirkwood@catalyst.net.nz> writes:
> Josh Berkus wrote:
>> 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.

>  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).

Huh?  *Archived* segments aren't supposed to get deleted, at least not
by any automatic Postgres action.  It would be up to the DBA how long
he wants to keep them around.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: HS/SR and smart shutdown
Next
From: "Sergey E. Koposov"
Date:
Subject: WARNING: pgstat wait timeout