Re: pg_cron installation on windows

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

sudo yum install -y pg_cron_16

Thanks,

On Mon, May 13, 2024 at 1:05 PM Kashif Zeeshan <kashi.zeeshan@gmail.com> 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@gmail.com> 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