Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7DJS-004Mxn-Pe for pgsql-admin@arkaria.postgresql.org; Wed, 15 May 2024 12:00:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7DJS-00FFNc-O7 for pgsql-admin@arkaria.postgresql.org; Wed, 15 May 2024 12:00:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7DJR-00FFIN-GQ for pgsql-admin@lists.postgresql.org; Wed, 15 May 2024 12:00:49 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s7DJO-000KNk-CF for pgsql-admin@lists.postgresql.org; Wed, 15 May 2024 12:00:47 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-572e48f91e9so1715781a12.0 for ; Wed, 15 May 2024 05:00:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1715774445; x=1716379245; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=kTDDK7IvCfN7OqksMXLKXlPav6yNsewJT915rzHezbA=; b=Zti+KWsmtClrCloQLhFx2/Uq+vxIRfXAGBLqbSr1sojcjBz6O+3Cj7AyA1mhMh2BTK 7Q6sH00kkQ2xtQzULjgBc3q5Z9OBkI8HyXcVBqEMd3MUMw914FxOCqZZH+ZoRycWgg4y LNxP/As4DpGIroNtG66tAX/nZM8ySLdmL4KQINZMGG8J7BVczR+PaJS7q08dXFdsW983 +XlLHXDAUjmPNn4XKE4DWNSqqZbSkosfW1oZH8Orwr39/X4+DmB2o8Ni3u1UTSlhL8YF pfvjir9p6cjhUekLf5H2NARe2sPg2ERZGJfbW+b8p1okTinSa9Xetbl9hhlgyCNGx1Oy cK8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1715774445; x=1716379245; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=kTDDK7IvCfN7OqksMXLKXlPav6yNsewJT915rzHezbA=; b=rZRsuRBAmYsFgHV/z38mhWjT904jnaJK1BmIKsGxlf1dFIJU3Lf+NyeSvTk/gicE83 bteui+O8I0nIrmLJcKwaftfg6p+QRZqil+j43AEvdZdSh99u4pCvxTes1R+589y7o+pN YBDtHlYPUOhavwLkOLN9sACy/fVaT1dbdJ7iMNfe2mjbWbRijkWnKhq3uNThOgE+ANCt uZ6VFSJXxFLAyFARizd3EM/2lE1o0ZGZJ6KBfc9BP2ELWE7lKuauvEryBcCsECTbR3Dj Wc9netZ1unT3iChs8Arb5O3iHy/jlWPYNZjocE2ilmWqSG0PNocuKjWLu+6D9MFi3A1n UWSQ== X-Gm-Message-State: AOJu0Yy1zBo38WlNuxSVNUtUlVsXK4GJcVK3b+i0n5FrJ0eN0dMopSYA GgtJroT4JnTAaMyrODuB7/5mJsncNUAsDfKSITRncBHINZm/MAqLltQBK0HRBFnuJkf9h+qtFXB bg/BNd6mV7ZcUmQgwx6EgZYYjnkPMz/qP X-Google-Smtp-Source: AGHT+IFpeqJAYd1PBQ8XVsZswSWPgTh4c5G0DDQsw+NSAZg9FKdQ6aQTLkmgg0Eghy3oK78KTQmIEqED84CssEWi1Do= X-Received: by 2002:a17:906:31d7:b0:a59:c7d9:9d39 with SMTP id a640c23a62f3a-a5a2d54c0b5mr1069652566b.10.1715774444731; Wed, 15 May 2024 05:00:44 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Daulat Date: Wed, 15 May 2024 17:30:33 +0530 Message-ID: Subject: Re: pg_cron installation on windows To: Kashif Zeeshan Cc: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000004b0c4e06187cded5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004b0c4e06187cded5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable [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=E2=80=AFPM Kashif Zeeshan wrote: > > > On Wed, May 15, 2024 at 4:30=E2=80=AFPM Daulat wro= te: > >> 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=3D/opt/PostgreSQL-14/bin/:$PATH >> make && sudo PATH=3D$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_fin= ish >> > > 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=E2=80=AFPM Kashif Zeeshan >> wrote: >> >>> Hi >>> >>> Please have a look on the following post. >>> >>> >>> https://stackoverflow.com/questions/68453688/how-do-i-install-the-pg-cr= on-extension-in-postgres-13-hosted-in-my-windows-10 >>> >>> Thanks & Regards >>> Kashif Zeeshan >>> Bitnine Global >>> >>> On Mon, May 13, 2024 at 12:03=E2=80=AFPM Daulat = wrote: >>> >>>> Hi Team, >>>> >>>> I need your help in installing the =E2=80=98*pg_cron*=E2=80=99 extensi= on in PostgreSQL >>>> running on a windows machine. My requirement is to schedule the >>>> execution of PostgreSQL Function at regular intervals from the Postgre= s >>>> database itself. >>>> >>>> >>>> Thanks >>>> >>> --0000000000004b0c4e06187cded5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
[ec2-user@ip-172-31-8-67 ~]$ sudo yum install -y pg_cron_1= 4
Loaded plugins: extras_suggestions, langpacks, update-motd
amzn2-co= re =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = 3.6 kB =C2=A000: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=E2=80=AFPM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:


On Wed, May 1= 5, 2024 at 4:30=E2=80=AFPM Daulat <daulat.dba@gmail.com> wrote:
Thanks, I'll = check it out.=C2=A0

Now, I have tried to install on = Amazon Linux this time using source code and=C2=A0 on postgres version 14.6= .

Steps:

git clone https://gi= thub.com/citusdata/pg_cron.git
cd pg_cron
# Ensure pg_config is i= n your path, e.g.
export PATH=3D/opt/PostgreSQL-14/bin/:$PATH
make &a= mp;& sudo PATH=3D$PATH make install

But ge= tting an error=C2=A0

/opt/PostgreSQL-14/lib/postgr= esql/pg_cron.so": /opt/PostgreSQL-14/lib/postgresql/pg_cron.so: undefi= ned symbol: elog_finish

It = seemed to be a compatibility issue, why dont=C2=A0you install the pg_cron f= rom the linux package instead of compiling.
The Github contains t= he instructions as well
sudo yum install -y pg_c=
ron_16
<= /div>
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=E2=80=AFPM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Thanks & Regards
Kashif Zeeshan
Bitnin= e Global

On Mon, May 13, 2024 at 12:03=E2=80=AFPM Daulat <daulat.dba@gmail.com= > wrote:
Hi Team,

I need= your help in installing the =E2=80=98pg_cron=E2=80=99 extension in PostgreSQL running on a windows machine.=C2=A0My requirement is to schedule the execution of PostgreSQL Function at regular intervals from the Postgres database itself.

=


<= p class=3D"MsoNormal" style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font-= family:Calibri,sans-serif">Thanks

=
--0000000000004b0c4e06187cded5--