pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: H <agents@meddatainc.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Installing extension temporal_tables for PG13
Date: Wed, 29 Nov 2023 16:15:29 -0500
Message-ID: <db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com> (raw)
In-Reply-To: <b632661d-5ad4-4452-9dc1-f7eea5ebe3c8@aklaver.com>
References: <e0080f4b-3bda-3163-c549-a052ffbf47e4@meddatainc.com>
	<cab0734e-521c-4e62-b602-1413dcb26d82@aklaver.com>
	<52433737-FB1D-434A-A5C7-849B3D201F04@meddatainc.com>
	<22b8d155-24ac-4f82-b4cf-b5dabc737f67@aklaver.com>
	<2f11d0df-35ec-65f5-379a-419d456fa61f@meddatainc.com>
	<06007753-23c0-4578-9f44-42e854b917cf@aklaver.com>
	<cc40250b-31bf-02a5-9190-6db98bcd7546@meddatainc.com>
	<440cfa70-a780-4f58-b7fb-6704f9790d60@aklaver.com>
	<D6C9FE15-1E13-4A7B-8FA2-35C208893372@meddatainc.com>
	<b632661d-5ad4-4452-9dc1-f7eea5ebe3c8@aklaver.com>

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






view thread (12+ messages)

Message-ID: <db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com>
Permalink:  ../db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com/
Also on:    postgresql.org/message-id/db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: agents@meddatainc.com
  Subject: Re: Installing extension temporal_tables for PG13
  In-Reply-To: <db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com>
  References: <e0080f4b-3bda-3163-c549-a052ffbf47e4@meddatainc.com> <cab0734e-521c-4e62-b602-1413dcb26d82@aklaver.com> <52433737-FB1D-434A-A5C7-849B3D201F04@meddatainc.com> <22b8d155-24ac-4f82-b4cf-b5dabc737f67@aklaver.com> <2f11d0df-35ec-65f5-379a-419d456fa61f@meddatainc.com> <06007753-23c0-4578-9f44-42e854b917cf@aklaver.com> <cc40250b-31bf-02a5-9190-6db98bcd7546@meddatainc.com> <440cfa70-a780-4f58-b7fb-6704f9790d60@aklaver.com> <D6C9FE15-1E13-4A7B-8FA2-35C208893372@meddatainc.com> <b632661d-5ad4-4452-9dc1-f7eea5ebe3c8@aklaver.com> <db70ce88-cd90-f031-71ce-a5f041040165@meddatainc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox