pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
7+ messages / 5 participants
[nested] [flat]
* PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
@ 2021-11-29 06:45 Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 7+ messages in thread
From: Gaurav Anand @ 2021-11-29 06:45 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org; +Cc: Swapnil Sonawane <swapnil.sonawane@saama.com>
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?
Thanks.
Regards,
Gaurav Anand
[image: logo] <https://bit.ly/3Eo7O68;
--
This communication is confidential and
subject to and governed by Saama’s
Electronic
Communications Disclaimer.
<https://www.saama.com/email-communication-disclaimer/;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
@ 2021-11-29 07:33 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-11-29 07:57 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Swapnil Sonawane <swapnil.sonawane@saama.com>
2021-11-29 08:17 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
0 siblings, 2 replies; 7+ messages in thread
From: Laurenz Albe @ 2021-11-29 07:33 UTC (permalink / raw)
To: Gaurav Anand <gaurav.anand@saama.com>; pgsql-admin@lists.postgresql.org; +Cc: Swapnil Sonawane <swapnil.sonawane@saama.com>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Laurenz Albe <laurenz.albe@cybertec.at>
@ 2021-11-29 07:57 ` Swapnil Sonawane <swapnil.sonawane@saama.com>
1 sibling, 0 replies; 7+ messages in thread
From: Swapnil Sonawane @ 2021-11-29 07:57 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Gaurav Anand <gaurav.anand@saama.com>; pgsql-admin@lists.postgresql.org
Hi Laurenz,
We are using installing 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
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
[image: logo] <https://bit.ly/3nqEeq7;
--
This communication is confidential and
subject to and governed by Saama’s
Electronic
Communications Disclaimer.
<https://www.saama.com/email-communication-disclaimer/;
Attachments:
error_While_Installing_Temporal_tables_For_PG13.PNG (image/png, 72.8K) download
view image
error2_While_Installing_Temporal_tables_For_PG13.PNG (image/png, 77.1K) download
view image
* Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Laurenz Albe <laurenz.albe@cybertec.at>
@ 2021-11-29 08:17 ` Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 09:02 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Gaurav Anand @ 2021-11-29 08:17 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin@lists.postgresql.org, Swapnil Sonawane <swapnil.sonawane@saama.com>
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
[image: logo] <https://bit.ly/3Eo7O68;
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.
<https://www.saama.com/email-communication-disclaimer/;
Attachments:
error_While_Installing_Temporal_tables_For_PG13.PNG (image/png, 72.8K) download
view image
error2_While_Installing_Temporal_tables_For_PG13.PNG (image/png, 77.1K) download
view image
* Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Laurenz Albe <laurenz.albe@cybertec.at>
2021-11-29 08:17 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
@ 2021-11-29 09:02 ` Ron <ronljohnsonjr@gmail.com>
2021-11-29 12:35 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
0 siblings, 1 reply; 7+ messages in thread
From: Ron @ 2021-11-29 09:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Laurenz Albe <laurenz.albe@cybertec.at>
2021-11-29 08:17 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 09:02 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Ron <ronljohnsonjr@gmail.com>
@ 2021-11-29 12:35 ` Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 18:28 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Edward J. Sabol <edwardjsabol@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Gaurav Anand @ 2021-11-29 12:35 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org, Swapnil Sonawane <swapnil.sonawane@saama.com>
Hello,
We tried that one also.
Have installed the package by using #sudo apt-get install -y
postgresql-server-dev-all
tried once again and getting the same error as versioning.c:249:16: error:
incompatible types when assigning to type ‘Form_pg_attribute’ {aka
‘FormData_pg_attribute *’} from type ‘FormData_pg_attribute’.
Please see the attached snap.
Thanks.
Regards,
Gaurav Anand
[image: logo] <https://bit.ly/3Eo7O68;
On Mon, Nov 29, 2021 at 2:32 PM Ron <ronljohnsonjr@gmail.com> wrote:
> 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
>
> [image: logo] <https://bit.ly/3Eo7O68;
>
>
> 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.
> <https://www.saama.com/email-communication-disclaimer/;
>
>
>
>
> --
> Angular momentum makes the world go 'round.
>
--
This communication is confidential and
subject to and governed by Saama’s
Electronic
Communications Disclaimer.
<https://www.saama.com/email-communication-disclaimer/;
Attachments:
error3_While_Installing_Temporal_tables_For_PG13.PNG (image/png, 74.4K) download
view image
* Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Laurenz Albe <laurenz.albe@cybertec.at>
2021-11-29 08:17 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 09:02 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Ron <ronljohnsonjr@gmail.com>
2021-11-29 12:35 ` Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
@ 2021-11-29 18:28 ` Edward J. Sabol <edwardjsabol@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Edward J. Sabol @ 2021-11-29 18:28 UTC (permalink / raw)
To: Gaurav Anand <gaurav.anand@saama.com>; +Cc: pgsql-admin@lists.postgresql.org
Going to https://pgxn.org/dist/temporal_tables/, I discovered that the latest version is 1.2.0, which was released in 2017. The CHANGELOG mentions adding support for PostgreSQL 10. I think you are trying to use it with PostgreSQL 12 or 13. Do you see the problem? That version of the temporal_tables extension does not support any version of PostgreSQL greater than 10.
The https://pgxn.org/dist/temporal_tables/ web page also has a link to the GitHub repository for the project: https://github.com/arkhipov/temporal_tables
If you go there and view the commits, you'll find that the most recent commit "make(s) temporal_tables extension compile with PostgreSQL 13". Unfortunately, it hasn't been released yet. I would advise cloning the GitHub repository and trying to compile that version. If you have problems, you should take it up with the temporal_tables developer by filing an issue at https://github.com/arkhipov/temporal_tables/issues. There's nothing the PostgreSQL team can do to help here.
Hope this helps,
Ed
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/
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2021-11-29 18:28 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-29 06:45 PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions. Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 07:33 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-11-29 07:57 ` Swapnil Sonawane <swapnil.sonawane@saama.com>
2021-11-29 08:17 ` Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 09:02 ` Ron <ronljohnsonjr@gmail.com>
2021-11-29 12:35 ` Gaurav Anand <gaurav.anand@saama.com>
2021-11-29 18:28 ` Edward J. Sabol <edwardjsabol@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