From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Date: Mon, 29 Nov 2021 03:02:43 -0600
Message-ID: <5b932ae0-820c-d34f-1d7f-19f786741119@gmail.com> (raw)
In-Reply-To: <CAMZ99nc6_sbVeuZjAU-dywhoxXMnGeUx1ESkgzJan9ABuXsD1A@mail.gmail.com>
References: <CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.com>
<d5dca6e1f58261828e86b3c513703bbd06380e84.camel@cybertec.at>
<CAMZ99nc6_sbVeuZjAU-dywhoxXMnGeUx1ESkgzJan9ABuXsD1A@mail.gmail.com>
It looks like you need to install the postresql development package. (I
don't know the exact name.)
On 11/29/21 2:17 AM, Gaurav Anand wrote:
> Hi Laurenz,
>
> Thank you for kind attention and acknowledging.
>
> We are using installation steps from the PGXN website
> _https://pgxn.org/dist/temporal_tables/
> <https://pgxn.org/dist/temporal_tables/>_
>
> After login in to docker (docker images is postgres:13.5), we are
> executing these installation steps:
> > apt-get install pip; sudo pip install pgxnclient; pgxn install
> temporal_tables
> *Error:*
> *pgxn install temporal_tables*
> INFO: best version: temporal_tables 1.2.0
> INFO: saving /tmp/tmp46d4nx9e/temporal_tables-1.2.0.zip
> INFO: unpacking: /tmp/tmp46d4nx9e/temporal_tables-1.2.0.zip
> INFO: building extension
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Werror=vla -Wendif-labels
> -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wformat-security
> -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -Wno-format-truncation -Wno-stringop-truncation -g -g -O2
> -fstack-protector-strong -Wformat -Werror=format-security
> -fno-omit-frame-pointer -fPIC -I. -I./ -I/usr/include/postgresql/13/server
> -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2
> -D_GNU_SOURCE -I/usr/include/libxml2 -c -o temporal_tables.o temporal_tables.c
> temporal_tables.c:9:10: fatal error: postgres.h: No such file or directory
> 9 | #include "postgres.h"
> | ^~~~~~~~~~~~
> compilation terminated.
> gmake: *** [<builtin>: temporal_tables.o] Error 1
> ERROR: command returned 2: gmake PG_CONFIG=/usr/bin/pg_config all
>
> *Please find the error logs in attachments*
>
> also tried a second way after cloning the repo executed below cmds but
> getting the same error like above
> |$ make $ make install $ make installcheck|
>
>
> Thanks.
>
> Regards,
> Gaurav Anand
>
> logo <https://bit.ly/3Eo7O68;
>
>
> On Mon, Nov 29, 2021 at 1:03 PM Laurenz Albe <laurenz.albe@cybertec.at
> <mailto:laurenz.albe@cybertec.at>> wrote:
>
> On Mon, 2021-11-29 at 12:15 +0530, Gaurav Anand wrote:
> > Hello Team,
> >
> > Our existing DB's are working with temporal table extension. We
> added this from the PGXN site and it works very well for PG 9 or 10.
> >
> > Now, we are trying to upgrade our DB's with PG 13. Hence I tried to
> install the same pgxn extension to enable the temporal table. But I am
> receiving the error like postgres.h file not present and
> > incompatible functions in versioning.c file
> >
> > Here are the steps:
> > apt-get install pip; sudo pip install pgxnclient; pgxn install
> temporal_tables
> >
> > I tried multiple ways mentioned in the site but getting the same
> error. Please see the snaps attached.
> >
> > Hence having some queries about it
> > 1. Does PGXN ext support any of the PG 12/13/14? Any alternate ways
> to install it with a particular version to avoid error?
> > 2. Kindly suggest a workaround if anyone has successfully tried?
>
> It may well be that the extension has a problem.
>
> You should quote the exact error messages, otherwise it is hard to say
> what is the matter.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
> <https://www.cybertec-postgresql.com;
>
>
> This communication is confidential and subject to and governed
> by Saama’sElectronic Communications Disclaimer.
> <https://www.saama.com/email-communication-disclaimer/;
>
--
Angular momentum makes the world go 'round.
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: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
In-Reply-To: <5b932ae0-820c-d34f-1d7f-19f786741119@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