Message-ID: <d5dca6e1f58261828e86b3c513703bbd06380e84.camel@cybertec.at>
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12
 and 13 versions.
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Gaurav Anand <gaurav.anand@saama.com>, pgsql-admin@lists.postgresql.org
Cc: Swapnil Sonawane <swapnil.sonawane@saama.com>
Date: Mon, 29 Nov 2021 08:33:49 +0100
In-Reply-To: 
 <CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.com>
References: 
	<CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/d5dca6e1f58261828e86b3c513703bbd06380e84.camel%40cybertec.at>
Precedence: bulk

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