From: Daulat <daulat.dba@gmail.com>
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_cron installation on windows
Date: Wed, 15 May 2024 17:30:33 +0530
Message-ID: <CALfOM6K5v-RDCeMQx0+aea-X5faCnNYTvkU-WwfSipFLW8GTpg@mail.gmail.com> (raw)
In-Reply-To: <CAAPsdhfLJOq_z3PPgH2+=_gbktvz2AJ8qN148WQ59gUmHh7dng@mail.gmail.com>
References: <CALfOM6J9Rz7LQNM4cofaAg6QOzXtdrc7Toyau9fC9kjbwr9_1g@mail.gmail.com>
<CAAPsdhd5sd6yAiu7ypK2MhdhndNiHVXRaMxp2kNj8R5BfOQWbw@mail.gmail.com>
<CALfOM6KQ-FR+iikGc3_DR3xvkXB3Z9iSygv89XAB5L55mrSutw@mail.gmail.com>
<CAAPsdhfLJOq_z3PPgH2+=_gbktvz2AJ8qN148WQ59gUmHh7dng@mail.gmail.com>
[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@gmail.com>
wrote:
>
>
> On Wed, May 15, 2024 at 4:30 PM Daulat <daulat.dba@gmail.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.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-h...
>>>
>>> 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
>>>>
>>>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: daulat.dba@gmail.com, kashi.zeeshan@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_cron installation on windows
In-Reply-To: <CALfOM6K5v-RDCeMQx0+aea-X5faCnNYTvkU-WwfSipFLW8GTpg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox