citusdata/pg_cron

Cant install

DavidBuch1 opened this issue · 1 comments

Hi
I am using postgres 15 on ubuntu 22.04 and have just tried to install pg_cron to no avail.
I assume the correct version to install is postgresql-15-cron.
I have added the sharelibraries as follows
shared_preload_libraries = 'pg_cron'
cron.database_name = 'azdb'
cron.timezone = 'AU'
and restarted the postgres server.
I then attempt to install the extension
CREATE EXTENSION pg_cron;
and get this error
ERROR: pg_cron can only be loaded via shared_preload_libraries
HINT: Add pg_cron to the shared_preload_libraries configuration variable in postgresql.conf.

SQL state: XX000

please help urgently.. what am I doing wrong?

thanks

Could there be another shared_preload_libraries somewhere in your postgresql.conf or postgresql.auto.conf that overrides the first?