Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8RuF-009uml-QD for pgsql-general@arkaria.postgresql.org; Wed, 29 Nov 2023 21:15:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r8RuE-00DDar-Gr for pgsql-general@arkaria.postgresql.org; Wed, 29 Nov 2023 21:15:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8RuE-00DDZO-5E for pgsql-general@lists.postgresql.org; Wed, 29 Nov 2023 21:15:38 +0000 Received: from mout.perfora.net ([74.208.4.196]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8RuB-009EOX-FS for pgsql-general@lists.postgresql.org; Wed, 29 Nov 2023 21:15:37 +0000 Received: from [192.168.1.17] ([72.94.51.172]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MIcHO-1rAdlS0Zxo-002CTh for ; Wed, 29 Nov 2023 22:15:30 +0100 Subject: Re: Installing extension temporal_tables for PG13 To: pgsql-general@lists.postgresql.org References: <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> <440cfa70-a780-4f58-b7fb-6704f9790d60@aklaver.com> From: H Message-ID: Date: Wed, 29 Nov 2023 16:15:29 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US X-Provags-ID: V03:K1:QF8wH+bm9sWoti0oIhVcLPOY7VHjAGZ5C1o4VsOr/PhqdiG/lBa wDAuV9kxlhJwM/26mWo0Iun3iHJLtpZD/Kl4RvcA7HNYKCpzE2XZ3PDGpQnYHONeil2L/ir QWHbZ95g3IXW/whX0/TSGDux1Igk+QTLQnKMWlua62TP1SmGQ35JINi/N0UcsR9VVXKHWSd 7i25P6ZE5kGdGmJ9WZcXA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:S73miDy9ViA=;xqo8mdiAVfDMusyr7uFrTBH5fKW 2xJMNrKKAKZNeeTrYxJO/4EKrsluEoDLh/BGc1/WckUnbjRriH7HJLDOPIDRa7KEv1Zbvcgpn srxWsguqvboJ1VBXSBTqKPBEiLtUk8z9O9IGSS+oNi012wSpXOk5l5pFMNkwu9TpDU4+pMOUj F4Ed4acePLYfDmdnqFqtcyLNBoZfxHZosZkOu/xErqxY9Kdl73CfrsuwnR+GD6sZDCGfXsxi7 lni701lR/30vgfNf/z5ecyRFuH/lt409wqI+KUtKmTQRnE5ePt8kgiuEKIHdzsAHP2bn16U3m mkimRqsxkG9QI/QcaGlkTHBlMVlGqv1GE9uMHWcC0e4juajg1K4IGTyV4bu1i/IlyN756ykkX qgt5LM92/WWUF8j2zEIWHM8ax6XYrd8cFX6Y97ZCaqSZDFpnMu+rP21r6Uhif5P5rHj11GZwj 4ax9aLycuMgJOY4OixxhQfSoIqrBvJTrZ2A570rqrIafMB1kAlfbRhTQYU2r3nm0Q7HFOFFgB VCF46dP/fgsqDSzwwuEAiZ1M+ulEhB3pLm3Bx1F5WyCSJbGD7D4h+f9LD0ybBBxKXRBVls2Q+ D/XF48rlbAlH3WdSN+vDfYDstxxbM4H6qmtL3tABwIY5XldzrdYEf23Wu+Fqui+Ytx4rf+96y qYyhppUwkwhuqsJJ1rEzNwNkxMNGm0Dcv7uPezTCQWT5C01Hzyh3n7B9ntk9mWuA4A55oZph+ 6ifeZ7/O4zWwZPURGOI09kMEZqlzIUQD6WEnbBy8LUFtFFcKyaQylMtzgtcbPYsTtmJEcVVWy 0emq0v0Lk3P7Xqna+LIpVBxvKxLdsi8DzmKHCe+m3wCeBpEIz/hPRBJNRxIQisBN4m2Qa/IIa fBBxFzgV7s8B0kQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 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.