pg_cron icon indicating copy to clipboard operation
pg_cron copied to clipboard

Published 20 hours ago • verified publisher icon citusdata

Cant install

Open DavidBuch1 opened this issue 1 year ago • 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

DavidBuch1 avatar Feb 05 '24 03:02 DavidBuch1

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

marcoslot avatar Feb 05 '24 08:02 marcoslot