Installing module for 9.6, not 9.2, on Centos?

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Installing module for 9.6, not 9.2, on Centos?
Date: 2017-05-23 04:41:54
Message-ID: CAD3a31UdeQ1goCKvVLQnn9-4w1_GE63A=mtTSJUEvWq0_ffFig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I recently installed 9.6 on my Centos 6.9 server, alongside a
still-running 9.2.

I need to install a module for 9.6 (table_log) that is installed on 9.2.
I took the table_log Makefile and changed it to point to
/usr/pgsql-9.6/bin/pg_config
instead of 9.2. It is still installing into the 9.2 directory though.

What's the cleanest or most proper way to target 9.6 in this situation?
Transcript below, and TIA.

Ken

[root(at)hosting table_log-0.4.4]# more Makefile

MODULES = table_log
DATA_built = table_log.sql
DOCS = README.table_log

ifdef USE_PGXS
PGXS := $(shell /usr/pgsql-9.6/bin/pg_config --pgxs)
include $(PGXS)
else
subdir = contrib/table_log
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
include $(top_srcdir)/contrib/contrib-global.mk
endif

[root(at)hosting table_log-0.4.4]# make USE_PGXS=1 clean
rm -f table_log.so table_log.o
rm -f table_log.sql

[root(at)hosting table_log-0.4.4]# make USE_PGXS=1

sed 's,MODULE_PATHNAME,$libdir/table_log,g' table_log.sql.in >table_log.sql

gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -fpic
-I. -I./ -I/usr/pgsql-9.2/include/server -I/usr/pgsql-9.2/include/internal
-D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o table_log.o
table_log.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -O2 -g -pipe -Wall
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
--param=ssp-buffer-size=4 -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -fpic
-L/usr/pgsql-9.2/lib -Wl,--as-needed -L/usr/lib64 -Wl,--as-needed
-Wl,-rpath,'/usr/pgsql-9.2/lib',--enable-new-dtags -shared -o table_log.so
table_log.o

[root(at)hosting table_log-0.4.4]# make USE_PGXS=1 install

/bin/mkdir -p '/usr/pgsql-9.2/share/contrib'
/bin/mkdir -p '/usr/pgsql-9.2/lib'
/bin/mkdir -p '/usr/pgsql-9.2/doc/contrib'
/usr/bin/install -c -m 644 table_log.sql '/usr/pgsql-9.2/share/contrib/'
/usr/bin/install -c -m 755 table_log.so '/usr/pgsql-9.2/lib/'
/usr/bin/install -c -m 644 .//README.table_log '/usr/pgsql-9.2/doc/contrib/'
--

AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://agency-software.org/demo/client
<https://agency-software.org/demo/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2017-05-23 13:17:40 Re: logical replication in PG10 BETA
Previous Message Steven Chang 2017-05-23 03:00:03 shard_manager extension on PGXN