Date: Thu, 29 Feb 2024 20:31:08 -0800
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
Message-ID: <20240301043108.63@rfd.leadboat.com>
References: 
 <MA0P287MB005252952926035DD08B7C36D75F2@MA0P287MB0052.INDP287.PROD.OUTLOOK.COM>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <MA0P287MB005252952926035DD08B7C36D75F2@MA0P287MB0052.INDP287.PROD.OUTLOOK.COM>
User-Agent: Mutt/2.2.12 (2023-09-09)
Archived-At: 
 <https://www.postgresql.org/message-id/20240301043108.63%40rfd.leadboat.com>
Precedence: bulk

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.