Sample Header Ad - 728x90

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