Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL shipping and ever expanding pg_xlog - Mailing list pgsql-performance

From Michael Dengler
Subject Re: WAL shipping and ever expanding pg_xlog
Date
Msg-id e8733d090706130912g794e5062hb0e95470eec6481c@mail.gmail.com
Whole thread Raw
In response to Re: WAL shipping and ever expanding pg_xlog  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
Tree view
Doug Knight just informed me about the pg_standby module.

Works like a charm!

Thanks

Mike


On 6/13/07, Merlin Moncure < mmoncure@gmail.com> wrote:
On 6/13/07, Michael Dengler < michael.dengler@gmail.com> wrote:
> OK....it looks like the slave machine has run out of space and that caused
> the xlog files to pile up on the master.
>
> Still...how do I prevent such all of the shipped WAL segments from remaining
> on the slave machine? Do I need to retain every single one? Can they be
> safely removed after the slave machine has restored the particular segment?

Are you using the pg_standy utility?  It has options to control this...

merlin

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: WAL shipping and ever expanding pg_xlog
Next
From: "Mark Wong"
Date:
Subject: Re: dbt2 NOTPM numbers