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 enable `archive_mode` at any time:
postgres=# select name,setting from pg_settings where name like 'archive_%';
name | setting
-----------------+------------
archive_command | (disabled)
archive_mode | off
archive_timeout | 0
Yes, I am aware 9.6 is pretty old, soon I will be replacing it with 11.x.
Thanks.
Kind regards.
śr., 22 gru 2021 o 19:18 Tom Lane <[email protected]> napisał(a):
> Zbigniew Kostrzewa <[email protected]> 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 are leftover from a time
> when you did have archiving on, and for some reason they are
> confusing the non-archive-mode cleanup logic.
>
> Anyway, you could certainly manually remove the .done files and
> the corresponding WAL segment files, and then see what happens.
>
> BTW, I'm sure you realize that 9.6.15 is not exactly current.
>
> regards, tom lane
>
