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
