Re: pg_cron installation on windows

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