From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Gaurav Anand <gaurav.anand@saama.com>
To: pgsql-admin@lists.postgresql.org
Cc: Swapnil Sonawane <swapnil.sonawane@saama.com>
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Date: Mon, 29 Nov 2021 08:33:49 +0100
Message-ID: <d5dca6e1f58261828e86b3c513703bbd06380e84.camel@cybertec.at> (raw)
In-Reply-To: <CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.com>
References: <CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, gaurav.anand@saama.com, pgsql-admin@lists.postgresql.org, swapnil.sonawane@saama.com
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
In-Reply-To: <d5dca6e1f58261828e86b3c513703bbd06380e84.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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