Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrcYl-0004Tt-Kc for pgsql-admin@arkaria.postgresql.org; Mon, 29 Nov 2021 09:02:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mrcYk-00057K-9B for pgsql-admin@arkaria.postgresql.org; Mon, 29 Nov 2021 09:02:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrcYj-00057B-Ty for pgsql-admin@lists.postgresql.org; Mon, 29 Nov 2021 09:02:49 +0000 Received: from mail-ot1-x333.google.com ([2607:f8b0:4864:20::333]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mrcYh-0005Gy-6J for pgsql-admin@lists.postgresql.org; Mon, 29 Nov 2021 09:02:49 +0000 Received: by mail-ot1-x333.google.com with SMTP id v15-20020a9d604f000000b0056cdb373b82so24600189otj.7 for ; Mon, 29 Nov 2021 01:02:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=c5jtWnN+dULqF7SBdKJ5FChc4BqJHaet74vr1hvOEWY=; b=Oyo43q38612szfswqM1WMNIFh2lECHxV37aTCoQILEoLT5/65oU/w/O8gswbdZucLj MIsSZ+VMGRxTSNVu6g5eR1Xg9MiWzOnHMwsMnAMO/7tgOzr9J45ucaWDo29VxUYFRvlv wNIX2OSeQE3iovEtCl6rv+tfVQ+f4Dm6l9XY8J36WmaliwCr4Lr19ojSEjtt6yJEDRuf z6+aQtIuar3Br2vUVZayUcvTTnfbJti5HwlsAkhF3EZDQ9FX/Aq25tiiRm+cRCwW7+po 7ly8dnOopfg5q88+NtxXTa/VNB9GxS6b8kiPEb6/CbbiSbDb8R9xVP6Ek1pJWzqh111n Ko+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=c5jtWnN+dULqF7SBdKJ5FChc4BqJHaet74vr1hvOEWY=; b=nnRVSQhiNs8j5p51NKUY2Nn7HD+JI71jfcJ0eBiVEA0X9dHyfhF/oFxFBmyTCAKlea yeHr1/+QbAJq2i7z2WBIgmPkpzwyMmRRg/zcww+Z2a5TfCIJuyJAC8aYYVArLLNKgfH0 pj+oHnwJGlBH1Ckb3C81A2V5TmF8xmhEcoS8iq5ppsfe4QXvG8iceAG0vexffrN3VuT6 voYSxj8zNVZ5n8YpvHvIcLiryY44le4Lo+8MRjQuQi5nc84juC1AfShAZSjz0osj0b2C LGuHE9vrUnpEkyHHpofw862SuWUplo4ck2r5V/2GiMkP0EE/zdECJnoTU2DgiyCFMpX8 Zrog== X-Gm-Message-State: AOAM532qMEB1B/rjcCqJUiRc7il/mvUpSADzfxXdg5Ne15mRj+wxvXgr A8vwYw0qtcDdGM+GHsGIPHRQMz2/AXs= X-Google-Smtp-Source: ABdhPJxn06kG7ws2Ol/mHReaVWD/L2KzbDqYCniEDW0Dn9dFfi29u7lVRcO2SpfACvNfUfNM94AyTg== X-Received: by 2002:a05:6830:1c6d:: with SMTP id s13mr44477156otg.177.1638176564692; Mon, 29 Nov 2021 01:02:44 -0800 (PST) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id z12sm2218620oor.45.2021.11.29.01.02.43 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 29 Nov 2021 01:02:44 -0800 (PST) Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <5b932ae0-820c-d34f-1d7f-19f786741119@gmail.com> Date: Mon, 29 Nov 2021 03:02:43 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------0D0AC51E7F0365B44B65C165" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0D0AC51E7F0365B44B65C165 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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/ > _ > > 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: *** [: 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 > > > On Mon, Nov 29, 2021 at 1:03 PM Laurenz Albe > 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 > > > > This communication is confidential and subject to and governed > by Saama’sElectronic Communications Disclaimer. > > -- Angular momentum makes the world go 'round. --------------0D0AC51E7F0365B44B65C165 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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/ 

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


On Mon, Nov 29, 2021 at 1:03 PM Laurenz Albe <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


This communication is confidential and subject to and governed by Saama’s Electronic Communications Disclaimer.

 


--
Angular momentum makes the world go 'round.
--------------0D0AC51E7F0365B44B65C165--