Does Postgres automatically rotate WAL files out (pg_xlog) if archive_mode is off?
6
votes
3
answers
6950
views
I'm relatively new to PostgreSQL administration and I'm attempting to pick up the nitty gritty details as I go. My question is, assuming I have no need for disaster recovery and I don't turn on archiving by setting up
archive_mode = on
, does Postgres have an internal mechanism to rotate WAL files out of pg_xlog
? if so, what is the frequency?
On a slightly different note, what is the impact of setting archive_mode = on
but not configuring an archive_command
- is there a default location Postgres will attempt to archive to?
Asked by kaizenCoder
(163 rep)
Nov 3, 2019, 11:32 PM
Last activity: Nov 4, 2019, 03:59 PM
Last activity: Nov 4, 2019, 03:59 PM