Re: Max number of WAL files in pg_xlog directory for Postgres 9.2 version

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 09/05/2018 12:39 PM, Raghavendra Rao J S V wrote:

Hi All,

We are using postgres 9.2 verstion database.

Please let me know, how many max number of wal files in pg_xlog directory?

What is the formul. I am seeing different formulas. Could you provide me which decides number of max WAL files in PG_XLOG directory for Postgres 9.2 Database,please?

If you're doing WAL file replication, and -- for whatever reason -- the standby system isn't applying them fast enough, there could be tens of thousands of files in pg_xlog.  (It would drain pretty quickly when you resolve the problem, though.)

--
Angular momentum makes the world go 'round.