Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.

Поиск
Список
Период
Сортировка
От Swapnil Sonawane
Тема Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Дата
Msg-id CAM3jsf+8zfWT1Tm-i+P51Bo-pPMGXy4ti8PytiBQpcaq5wpypg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Дерево обсуждения
Hi Laurenz,

We are using installing 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
Swapnil Sonawane

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



--
Thanks & Regards,
Swapnil Sonawane
logo

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

 

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Следующее
От: Gaurav Anand
Дата:
Сообщение: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.