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.klaver@aklaver.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.klaver@aklaver.com