Re: Number of WAL segment

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,