Re: pg_cron installation on windows

Hello Daulat,

You can download and install pg_cron_14 from the following PG14 repository
https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-8-x86_64/

Hopefully this helps you..

Regards,
Zaid Shabbir

On Wed, May 15, 2024 at 5:00 PM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:

> [ec2-user(at)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(at)ip-172-31-8-67 ~]$
>
> On Wed, May 15, 2024 at 5:17 PM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
> wrote:
>
>>
>>
>> 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
>>>>>
>>>>