Re: Installing extension temporal_tables for PG13

On 11/27/23 18:18, H wrote:
> On November 27, 2023 8:48:35 PM GMT-05:00, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> 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?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com