From: Noah Misch <noah@leadboat.com>
To: Ramya Ashwin <RamyaAshwin@zealogics.co>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: Facing issue in installing pg_cron extension in Postgresql 15
Date: Thu, 29 Feb 2024 20:31:08 -0800
Message-ID: <20240301043108.63@rfd.leadboat.com> (raw)
In-Reply-To: <MA0P287MB005252952926035DD08B7C36D75F2@MA0P287MB0052.INDP287.PROD.OUTLOOK.COM>
References: <MA0P287MB005252952926035DD08B7C36D75F2@MA0P287MB0052.INDP287.PROD.OUTLOOK.COM>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noah@leadboat.com, RamyaAshwin@zealogics.co, pgsql-bugs@lists.postgresql.org
Subject: Re: Facing issue in installing pg_cron extension in Postgresql 15
In-Reply-To: <20240301043108.63@rfd.leadboat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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