Re: Number of WAL segment - Mailing list pgsql-general

From Suzuki Hironobu
Subject Re: Number of WAL segment
Date
Msg-id 52389095.3020709@interdb.jp
Whole thread Raw
In response to Number of WAL segment  (tdev457 <idzob23@gmail.com>)
Responses Re: Number of WAL segment
List pgsql-general
Hi,

(13/09/17 21:46), tdev457 wrote:
> Hi,
> I am using PostgreSQL 8.3.8!!!
> How can I increase number of WAL segments in pg_xlog???
> Current settings are:
> checkpoint_segments=10
> checkpoint_completion_target=0.5
>
> WAL segments are generated every 10 min and I want to keep WAL segments in
> pg_xlog for at least 3h.

In 8.3, the number of wal segments can not be controlled explicitly.
# If you can use version 9.0 or higher,  please see here:
#
http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html#GUC-WAL-KEEP-SEGMENTS

In any case, It is not possible to control the retention period.
I recommend WAL Archiving, if you want to save 3 hour's wal segments
with certainty.

Regards,





pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: How to compare the results of two queries?
Next
From: Juan Daniel Santana Rodés
Date:
Subject: Re: How to compare the results of two queries?