Re: WAL files keep piling up

2022-01-03 Thread Zbigniew Kostrzewa
> > I have a PostgreSQL (9.6.15) two node cluster setup with Patroni. The > instances are configured to work in master <-> synchronous standby setup > and both run in docker containers with pgdata volume mounted from host. > When master is restarted the synchronous standby automatically takes the >

Re: WAL files keep piling up

2021-12-23 Thread Laurenz Albe
On Wed, 2021-12-22 at 20:26 +0100, Zbigniew Kostrzewa wrote: > Yes, I am aware 9.6 is pretty old, soon I will be replacing it with 11.x. > Thanks. v11 is old as well. I suggest v14. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com

Re: WAL files keep piling up

2021-12-22 Thread Zbigniew Kostrzewa
I've just checked my second reproduction cluster (also Patroni but this time on K8s). It also has non-empty `archive_status/` directory: ls pg_xlog/ | grep -v history | wc -l 165 ls pg_xlog/archive_status/ | wc -l 81 ls pg_xlog/archive_status/ | grep done | wc -l 81 but on this cluster I did not

Re: WAL files keep piling up

2021-12-22 Thread Tom Lane
Zbigniew Kostrzewa writes: > Thanks for responding. On current master it looks like so: > ls pg_xlog/archive_status/ | grep ready | wc -l > 0 > ls pg_xlog/archive_status/ | grep done | wc -l > 501 Hmm, if you've got archiving turned off, I wonder why you have any .done files at all. Perhaps they

Re: WAL files keep piling up

2021-12-22 Thread Zbigniew Kostrzewa
Thanks for responding. On current master it looks like so: ls pg_xlog/archive_status/ | grep ready | wc -l 0 ls pg_xlog/archive_status/ | grep done | wc -l 501 Kind regards. śr., 22 gru 2021 o 19:01 Ninad Shah napisał(a): > A stupid question. How many .ready files are there? > > > Regards, >

Re: WAL files keep piling up

2021-12-22 Thread Ninad Shah
A stupid question. How many .ready files are there? Regards, Ninad Shah On Wed, 22 Dec 2021 at 21:04, Zbigniew Kostrzewa wrote: > Hi, > > I have a PostgreSQL (9.6.15) two node cluster setup with Patroni. The > instances are configured to work in master <-> synchronous standby setup > and both

WAL files keep piling up

2021-12-22 Thread Zbigniew Kostrzewa
Hi, I have a PostgreSQL (9.6.15) two node cluster setup with Patroni. The instances are configured to work in master <-> synchronous standby setup and both run in docker containers with pgdata volume mounted from host. When master is restarted the synchronous standby automatically takes the role o