On 11/28/2023 12:38 AM, Adrian Klaver wrote: > On 11/27/23 18:18, H wrote: >> On November 27, 2023 8:48:35 PM GMT-05:00, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: >>> On 11/27/23 17:41, H wrote: >>>> On 11/27/2023 08:38 PM, Adrian Klaver wrote: >>>>> On 11/27/23 17:17, H wrote: > >>> I don't use PGXN so I am flying blind here. You may need to do: >>> >>> sudo pgxn install temporal_tables >> >> I ran pgxn install temporal_tables as root so that should not be the problem. >> > > On an old machine running openSUSE I did: > > sudo pgxn install --pg_config=/usr/local/pgsql15/bin/pg_config temporal_tables > > > Where this > > l /usr/local/pgsql15/lib64/pgxs/src/makefiles/pgxs.mk > -rw-r--r-- 1 root root 14768 Sep 25 09:23 /usr/local/pgsql15/lib64/pgxs/src/makefiles/pgxs.mk > > was already installed. I presume as part of the source build I did for Postgres 15. > > Maybe the Centos packaging has a separate package you need to install to get the PGXS infrastructure? > > > > It took a little bit of work and required multiple steps since pgxs is part of the postgresql13-devel package. It also required upgrading LLVM and installing gcc. Note that I am running this particular postgresql13 installation in a docker container. With pgxs installed I could then proceed to install temporal_tables extension using pgxn. Thank you for pointing me in the right direction.
