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@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@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@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@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.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
