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,
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
