Re: pg_cron installation on windows

[Daulat <daulat.dba@xxxxxxxxx>]

[ec2-user@ip-172-31-8-67 ~]$ sudo yum install -y pg_cron_14
Loaded plugins: extras_suggestions, langpacks, update-motd
amzn2-core                                                                                                        | 3.6 kB  00:00:00
No package pg_cron_14 available.
Error: Nothing to do
[ec2-user@ip-172-31-8-67 ~]$

On Wed, May 15, 2024 at 5:17 PM Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx> wrote:

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 install

But 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

You need to change _16 with _14 as you are using PG14.

Regards

Kashif Zeeshan

Bitnine Global

Thanks,

On Mon, May 13, 2024 at 1:05 PM Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx> wrote:

Hi

Please have a look on the following post.

https://stackoverflow.com/questions/68453688/how-do-i-install-the-pg-cron-extension-in-postgres-13-hosted-in-my-windows-10

Thanks & Regards

Kashif Zeeshan

Bitnine Global

On 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