Re: Installing extension temporal_tables for PG13

From: H <agents(at)meddatainc(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Installing extension temporal_tables for PG13
Date: 2023-11-29 21:15:29
Message-ID: db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(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?
>
>
>
>
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2023-11-29 21:54:43 Re: Removing oids with pg_repack
Previous Message Dirschel, Steve 2023-11-29 21:14:44 RE: [EXT] Re: Query runtime differences- trying to understand why.