Cant install
- Dominant language
- C
- Stars
- 3.9k
- Forks
- 260
- Avg merge
- 5d 5h
- Merged PRs (30d)
- 1
Description
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
Contributor guide
No contributing guide indexed for this repository
Research direction
The issue provides no repository file, test, or entry point to investigate. Start by reproducing CREATE EXTENSION pg_cron with the shown PostgreSQL 15 and Ubuntu 22.04 settings, then verify the shared_preload_libraries configuration and restart behavior. Done means identifying the configuration cause or documenting whether the reported setup works.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, ubuntu
- Domain
- databases, operating-systems
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100