Home > mailing lists

postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` - Mailing list pgsql-admin

From	Mohan NBSPS
Subject	postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
Date	June 1 02:00:52
Msg-id	CAPCvfWcOxdKpRqn7rYJKQTt7GscG_OHsftm-Qc2Byfkp9ux9kQ@mail.gmail.com Whole thread Raw
Responses	Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`
List	pgsql-admin

Hello Community,

Although the WAL retaining settings are default (max size 1GB),

`wal_keep_segments` is 25, checkpoint target is 2.5 minutes(default).

I noticed a few WAL files in secondary nodes (streaming replication) `pg_xlog`

folder.

What could be the reason why postgresql did not delete these ?

Thank you

Regards

Mohan

From: "Wetmore, Matthew (CTR)"
Date: 31 May, 21:49:20
Subject: Queries in replica are failing

From: Muhammad Imtiaz
Date: 01 June, 06:58:03
Subject: Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`