Re: pg_cron installation on windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[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.


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


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux