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?