Re: WAL files keep piling up

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Zbigniew Kostrzewa <zkostrzewa@xxxxxxxxx> 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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux