Re: Log files polluted with permission denied error messages after every 10 seconds

[Andrus <kobruleht2@xxxxxx>]

Hi!

    These are generated on Windows when removing a past WAL segment,
    where the process involves a rename followed by durable_unlink()
    that would
> generate some LOG entries in the logs if the internal unlink() failed
> (see RemoveXlogFile() in xlog.c). 
>

I changed wal_recycle to off. So checkpointer should no more try to rename wal files. Iit still tries to rename files. No idea way it does not use this setting:

2021-03-06 19:44:28 EET     checkpointer LOG:  could not rename file "pg_wal/0000000100000006000000EB": Permission denied

    2021-03-06 19:44:38 EET     checkpointer LOG:  could not rename file
    "pg_wal/0000000100000006000000F0": Permission denied
    2021-03-06 19:44:48 EET     checkpointer LOG:  could not rename file
    "pg_wal/0000000100000006000000F7": Permission denied
    2021-03-06 19:44:58 EET     checkpointer LOG:  could not rename file
    "pg_wal/0000000100000006000000FB": Permission denied
    2021-03-06 19:45:08 EET     postmaster LOG:  received SIGHUP,
    reloading configuration files
    2021-03-06 19:45:08 EET     postmaster LOG:  parameter "wal_recycle"
    changed to "off"
    2021-03-06 19:45:08 EET     checkpointer LOG:  could not rename file
    "pg_wal/0000000100000006000000FE": Permission denied
    2021-03-06 19:45:18 EET     checkpointer LOG:  could not rename file
    "pg_wal/0000000100000006000000FF": Permission denied
    2021-03-06 19:45:28 EET     checkpointer LOG:  could not rename file
    "pg_wal/000000010000000700000000": Permission denied
    2021-03-06 19:45:38 EET     checkpointer LOG:  could not rename file
    "pg_wal/000000010000000700000002": Permission denied
    2021-03-06 19:45:48 EET     checkpointer LOG:  could not rename file
    "pg_wal/000000010000000700000011": Permission denied
    2021-03-06 19:45:59 EET     checkpointer LOG:  could not rename file
    "pg_wal/000000010000000700000012": Permission denied

2021-03-06 19:46:09 EET     checkpointer LOG:  could not rename file "pg_wal/000000010000000700000015": Permission denied

2021-03-06 19:46:19 EET     checkpointer LOG:  could not rename file "pg_wal/000000010000000700000016": Permission denied

Should chekpointer process terminated to force it to use new setting. Is it safe to kill it during database usage.

    Andrus.