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

From: Gaurav Anand <gaurav(dot)anand(at)saama(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Cc: Swapnil Sonawane <swapnil(dot)sonawane(at)saama(dot)com>
Subject: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Date: 2021-11-29 06:45:00
Message-ID: CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/>

 

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-11-29 07:33:49 Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Previous Message SQL Padawan 2021-11-27 17:39:12 Re: Postgres-XL