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.hofm...@fhnw.ch<mailto:elke.hofm...@fhnw.ch> www.fhnw.ch/de/personen/elke-hofmann<http://www.fhnw.ch/de/personen/elke-hofmann>
