citusdata / citusdata/pg_cron

Cant install

Open
#309 1 comment 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.