Issues installing `pg_cron` on Neon with postgres 18

Hey guys! I'm following this guide but can't make Postgres to install

pg_cron

pg_cron

.

I've successfully ran the

PATCH

PATCH

updating the compute endpoint and

POST

POST

restarting it but when I go into SQL Editor and run

CREATE EXTENSION IF NOT EXISTS pg_cron;

CREATE EXTENSION IF NOT EXISTS pg_cron;

I see this message:

ERROR: pg_cron can only be loaded via shared_preload_libraries (SQLSTATE XX000)
HINT: Add pg_cron to the shared_preload_libraries configuration variable in postgresql.conf.

ERROR: pg_cron can only be loaded via shared_preload_libraries (SQLSTATE XX000)
HINT: Add pg_cron to the shared_preload_libraries configuration variable in postgresql.conf.

I've tried in two different projects with no luck. Both with Postgres 18.

Thanks!

Neon•5mo ago•

4 replies

dry-scarlet

Issues installing `pg_cron` on Neon with postgres 18

Hey guys! I'm following this guide but can't make Postgres to install

pg_cron

pg_cron

.

I've successfully ran the

PATCH

PATCH

updating the compute endpoint and

POST

POST

restarting it but when I go into SQL Editor and run

CREATE EXTENSION IF NOT EXISTS pg_cron;

CREATE EXTENSION IF NOT EXISTS pg_cron;

I see this message:

ERROR: pg_cron can only be loaded via shared_preload_libraries (SQLSTATE XX000)
HINT: Add pg_cron to the shared_preload_libraries configuration variable in postgresql.conf.

ERROR: pg_cron can only be loaded via shared_preload_libraries (SQLSTATE XX000)
HINT: Add pg_cron to the shared_preload_libraries configuration variable in postgresql.conf.

I've tried in two different projects with no luck. Both with Postgres 18.

Thanks!

Issues installing `pg_cron` on Neon with postgres 18

Similar Threads

Issues installing `pg_cron` on Neon with postgres 18

Similar Threads

Similar Threads

Similar Threads