Re: pg_cron installation on windows

On Wed, May 15, 2024 at 4:30 PM Daulat <daulat(dot)dba(at)gmail(dot)com> 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(dot)zeeshan(at)gmail(dot)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(dot)dba(at)gmail(dot)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
>>>
>>