pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_cron installation on windows
6+ messages / 3 participants
[nested] [flat]
* pg_cron installation on windows
@ 2024-05-13 07:02 Daulat <daulat.dba@gmail.com>
2024-05-13 07:35 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Daulat @ 2024-05-13 07:02 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_cron installation on windows
2024-05-13 07:02 pg_cron installation on windows Daulat <daulat.dba@gmail.com>
@ 2024-05-13 07:35 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 11:30 ` Re: pg_cron installation on windows Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Kashif Zeeshan @ 2024-05-13 07:35 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_cron installation on windows
2024-05-13 07:02 pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-13 07:35 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
@ 2024-05-15 11:30 ` Daulat <daulat.dba@gmail.com>
2024-05-15 11:46 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Daulat @ 2024-05-15 11:30 UTC (permalink / raw)
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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
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
>>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_cron installation on windows
2024-05-13 07:02 pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-13 07:35 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 11:30 ` Re: pg_cron installation on windows Daulat <daulat.dba@gmail.com>
@ 2024-05-15 11:46 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 12:00 ` Re: pg_cron installation on windows Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Kashif Zeeshan @ 2024-05-15 11:46 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>>>
>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_cron installation on windows
2024-05-13 07:02 pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-13 07:35 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 11:30 ` Re: pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-15 11:46 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
@ 2024-05-15 12:00 ` Daulat <daulat.dba@gmail.com>
2024-05-15 14:15 ` Re: pg_cron installation on windows Zaid Shabbir <zaidshabbir@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Daulat @ 2024-05-15 12:00 UTC (permalink / raw)
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
[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
>>>>
>>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pg_cron installation on windows
2024-05-13 07:02 pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-13 07:35 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 11:30 ` Re: pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-15 11:46 ` Re: pg_cron installation on windows Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 12:00 ` Re: pg_cron installation on windows Daulat <daulat.dba@gmail.com>
@ 2024-05-15 14:15 ` Zaid Shabbir <zaidshabbir@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Zaid Shabbir @ 2024-05-15 14:15 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: Kashif Zeeshan <kashi.zeeshan@gmail.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
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.dba@gmail.com> wrote:
> [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
>>>>>
>>>>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-05-15 14:15 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-13 07:02 pg_cron installation on windows Daulat <daulat.dba@gmail.com>
2024-05-13 07:35 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 11:30 ` Daulat <daulat.dba@gmail.com>
2024-05-15 11:46 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-15 12:00 ` Daulat <daulat.dba@gmail.com>
2024-05-15 14:15 ` Zaid Shabbir <zaidshabbir@gmail.com>
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