pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Facing issue in installing pg_cron extension in Postgresql 15 2+ messages / 2 participants [nested] [flat]
* Facing issue in installing pg_cron extension in Postgresql 15 @ 2024-02-29 11:19 Ramya Ashwin <RamyaAshwin@zealogics.co> 0 siblings, 1 reply; 2+ messages in thread From: Ramya Ashwin @ 2024-02-29 11:19 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org> EXTERNAL EMAIL: DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. </p Hi Team, I need to run a job which schedule everyday at midnight and for that am trying to add pg_cron extension in Postgresql 15. I followed the instructions and updated the postgresql.conf from the data directory. Ater that it is recommended to restart the DB inorder to get all the configurations implemented. When I restated the Postgresql, it stopped and couldn't able to restart and leads to reinstalling the same. Please help to do the pg_cron installation without restarting the DB. Regards, Ramya ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Facing issue in installing pg_cron extension in Postgresql 15 @ 2024-03-01 04:31 Noah Misch <noah@leadboat.com> parent: Ramya Ashwin <RamyaAshwin@zealogics.co> 0 siblings, 0 replies; 2+ messages in thread From: Noah Misch @ 2024-03-01 04:31 UTC (permalink / raw) To: Ramya Ashwin <RamyaAshwin@zealogics.co>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org> On Thu, Feb 29, 2024 at 11:19:19AM +0000, Ramya Ashwin wrote: > I need to run a job which schedule everyday at midnight and for that am > trying to add pg_cron extension in Postgresql 15. I followed the > instructions and updated the postgresql.conf from the data directory. Ater > that it is recommended to restart the DB inorder to get all the > configurations implemented. This mailing list is for bugs in core PostgreSQL. pg_cron is out of scope. You could try https://github.com/citusdata/pg_cron/issues. > When I restated the Postgresql, it stopped and couldn't able to restart and > leads to reinstalling the same. When "it stopped and couldn't able to restart", there must have been associated log messages. Wherever you post, do share the exact log messages that led to your conclusions. > Please help to do the pg_cron installation without restarting the DB. https://github.com/citusdata/pg_cron#setting-up-pg_cron does require changing shared_preload_libraries, which requires a restart. If you haven't already done that, there's no supported way to avoid a restart. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-03-01 04:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-02-29 11:19 Facing issue in installing pg_cron extension in Postgresql 15 Ramya Ashwin <RamyaAshwin@zealogics.co> 2024-03-01 04:31 ` Noah Misch <noah@leadboat.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox