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 1r7n6E-006opc-E3 for pgsql-general@arkaria.postgresql.org; Tue, 28 Nov 2023 01:41:18 +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 1r7n6A-001cAQ-QT for pgsql-general@arkaria.postgresql.org; Tue, 28 Nov 2023 01:41:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7n6A-001cAI-G3 for pgsql-general@lists.postgresql.org; Tue, 28 Nov 2023 01:41:14 +0000 Received: from mout.perfora.net ([74.208.4.194]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7n67-007h6p-JE for pgsql-general@lists.postgresql.org; Tue, 28 Nov 2023 01:41:13 +0000 Received: from [192.168.1.17] ([72.94.51.172]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with ESMTPSA (Nemesis) id 1Mw8kq-1rOM4n3i0i-00s656 for ; Tue, 28 Nov 2023 02:41:10 +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> From: H Message-ID: Date: Mon, 27 Nov 2023 20:41:08 -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: <06007753-23c0-4578-9f44-42e854b917cf@aklaver.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US X-Provags-ID: V03:K1:EkgMMD5w8AK+7+Yv40uc882bVMwXV4xI3V6HSrk/SskVofDUReJ 40700uCuPZ7wf6mPzTm5APtbJram7SomgGhuy0Fcmc6Eo7s94imkTZBEAUveLm7pXYXa+gr SLD1cx13EIduDVVpGZmuZ3HENlgIAmV0LqnKTvy6FjmVaoeb0x2y4aC63SjpQvyp/9WkDDI gSRZNBLLTq96hLNRA81ug== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:wy03rA6XJ/w=;riMGPX5jF0rA6KGz/0MuWbxJyRB 1tBYuKBo3w/HOYqLlm6LH3/52ul1H1KbXotuqgry5A+O6eBUJR5NuodLTqk7eyuh3vM8KthjS 1fzPkIauUtQT4t2JgHYGaiUt9o0ZoiW2WCup9pexIFFREvETwZErGhnNGJ6PMb75aoPz96Gn0 4krD2vo8sC+xAevmMUzs0KimpWooiGiRB7VR2pPcHuIdivTxekDA3tDI8ejAhCtumSsltZONn WK4OIWzPABiF9+PZFgWCNHRS4v2MOBvu7FziSe7MWOZnSHfLpDfJ010ppHBCfgRFs0/hPhV+f ZiCU1qxt28/DE16fCVot+3BeTpgDimo4Dfwc83slhxcFLihmOys5dh0Dph0Dq6Raa40L0Sqtg W2MrZF4oyiQbYh4X5gIyC7nEjOaQ58UyNHAFkPO6q7y+J/8g6hMEL9qqhiUmIA9O4ybXcS4P8 4f2Dmm6CffCeDU4NMSvII+b9U29W7uFaXoC2Q0UuhACwvjCpfT55zcoz09wFe/7JvRgQdiPYn SRrsYRwvI+jcWXHPGkS44tx9CKJW/3s+km+LK82BmDeChnlPzvDPw+Wq33ZIn8IlfdOhKGmYP EWGclKZZvIsK5yVikQMhqfuQFrYXDSVq849KompFR2ytGhwOqdp64eOEZAhRgQE9ZBYCz774v B/V2BmoDXi3h0CFOc/ccL2HtKKd9N3ny8m1wHcl45gXTC12aTK0gMLrAGz60QwE4xaxmP92gv 4KqZ+IyBWIYIaRfpOdXHDOvuev1EsFHvztFkwo+meyxmjQK7zDNOZ9ScTC3rHLpl/Dk3Ac3PB lEyBeIGPwkCO9dlU62ic2z6DZaNXwC89nodEmJ2pVbHSaqPr1OBQuW1/HpkN/5GwD79t8ZqhQ nT5Ey39wywTY5gg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/27/2023 08:38 PM, Adrian Klaver wrote: > On 11/27/23 17:17, H wrote: >> On 11/27/2023 07:26 PM, Adrian Klaver wrote: >>> On 11/27/23 16:18, H wrote: >>> >>>> The link to the pgxn client on the arkhipov's page leads to a non-functioning website: pgxnclient.projects.pgfoundry.org. >>>> >>>> Does anyone if the pgxn client can be found somewhere else? >>>> >>> >>> Or: >>> >>> https://pgxn.github.io/pgxnclient/ >>> >> Downloaded pgxn and first running: >> >> pgxn install temporal_tables >> >> but then running into another problem: >> >> GNUmakefile:25: /usr/pgsql-13/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory >> gmake: *** No rule to make target `/usr/pgsql-13/lib/pgxs/src/makefiles/pgxs.mk'.  Stop. >> ERROR: command returned 2: gmake PG_CONFIG=/usr/pgsql-13/bin/pg_config all >> >> I have both make and gmake installed on the system but the issue seems to be that the file pgxs.mk does not exist? In fact, I can see that /usr/pgsql-13/lib/pgxs directory does not exist. >> >> Suggestions? > > What does running > >    pg_config > > at the command line return? > >> >> >> > BINDIR = /usr/pgsql-13/bin DOCDIR = /usr/pgsql-13/doc HTMLDIR = /usr/pgsql-13/doc/html INCLUDEDIR = /usr/pgsql-13/include PKGINCLUDEDIR = /usr/pgsql-13/include INCLUDEDIR-SERVER = /usr/pgsql-13/include/server LIBDIR = /usr/pgsql-13/lib PKGLIBDIR = /usr/pgsql-13/lib LOCALEDIR = /usr/pgsql-13/share/locale MANDIR = /usr/pgsql-13/share/man SHAREDIR = /usr/pgsql-13/share SYSCONFDIR = /etc/sysconfig/pgsql PGXS = /usr/pgsql-13/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE =  '--enable-rpath' '--prefix=/usr/pgsql-13' '--includedir=/usr/pgsql-13/include' '--mandir=/usr/pgsql-13/share/man' '--datadir=/usr/pgsql-13/share' '--libdir=/usr/pgsql-13/lib' '--enable-tap-tests' '--with-icu' '--with-llvm' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--enable-dtrace' '--with-uuid=e2fs' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-selinux' '--with-systemd' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/pgsql-13/doc' '--htmldir=/usr/pgsql-13/doc/html' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic' 'LDFLAGS=-Wl,--as-needed' 'LLVM_CONFIG=/usr/lib64/llvm5.0/bin/llvm-config' 'CLANG=/opt/rh/llvm-toolset-7/root/usr/bin/clang' 'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig' 'PYTHON=/usr/bin/python3' CC = gcc -std=gnu99 CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic CFLAGS_SL = -fPIC LDFLAGS = -Wl,--as-needed -L/usr/lib64/llvm5.0/lib -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/usr/pgsql-13/lib',--enable-new-dtags LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgcommon -lpgport -lpthread -lselinux -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -ldl -lm VERSION = PostgreSQL 13.13