Dear community
I write as I am not sure if the issue I report is caused by Debian.
On 23-10-10 we upgraded our Debian bullseye servers to version 11.8. Along came a new version of postgresql-12-cron:
postgresql-12-cron 1.6.0-1.pgdg110+1
pg_cron executes jobs one day too early since then.
I opened an issue here:
https://github.com/citusdata/pg_cron/issues/290
We reproduced the problem with postgresql 13/ postgresql-13-cron.
We could fix the problem temporarily with setting cron.timezone to ‘GMT+24’ in /etc/postgresql/<version>/main/postgresql.conf
Thank you in advance for any advice
Best, Elke Hofmann
Fachhochschule Nordwestschweiz FHNW
Hochschule für Life Sciences
Prof. Elke Hofmann
Leiterin Applikationsentwicklung/Datenmanagement Ausbildung
Co-Verantwortliche Studierendenprojekte
Hofackerstrasse 30
4132 Muttenz
T +41 061 228 54 01
M +41 78 600 47 39 (SMS)
------------------------------------------------------------
elke.hofmann@fhnw.ch
www.fhnw.ch/de/personen/elke-hofmann