On Wed, May 15, 2024 at 4:30 PM Daulat <daulat.dba@xxxxxxxxx> wrote:
Thanks, I'll check it out.Now, I have tried to install on Amazon Linux this time using source code and on postgres version 14.6.Steps:git clone https://github.com/citusdata/pg_cron.git
cd pg_cron
# Ensure pg_config is in your path, e.g.
export PATH=/opt/PostgreSQL-14/bin/:$PATH
make && sudo PATH=$PATH make installBut getting an error/opt/PostgreSQL-14/lib/postgresql/pg_cron.so": /opt/PostgreSQL-14/lib/postgresql/pg_cron.so: undefined symbol: elog_finish
It seemed to be a compatibility issue, why dont you install the pg_cron from the linux package instead of compiling.
The Github contains the instructions as well
sudo yum install -y pg_cron_16
Regards
Kashif Zeeshan
Bitnine Global
Thanks,On Mon, May 13, 2024 at 1:05 PM Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx> wrote:HiPlease have a look on the following post.Thanks & RegardsKashif ZeeshanBitnine GlobalOn Mon, May 13, 2024 at 12:03 PM Daulat <daulat.dba@xxxxxxxxx> wrote:Hi Team,I need your help in installing the ‘pg_cron’ extension in PostgreSQL running on a windows machine. My requirement is to schedule the execution of PostgreSQL Function at regular intervals from the Postgres database itself.
Thanks