On 05/23/2017 04:54 PM, Ken Tanzer wrote:
Thanks Adrian, though still no luck for me. The compiling was working
OK already, the install still goes to 9.2.
Where did you get the table_log extension
I no longer remember (it's been a few years), but my tgz file was the
same as what's on pgfoundry
I usually do something like(using existing Makefile):
PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 clean all
...
Though in both cases the extension did not actually compile due to
errors.
That worked fine for me. (Somewhere along the way I added these two
lines to table_log.c:
+#include <utils/rel.h>
|
+#include <utils/timestamp.h>
)
But the install still goes to 9.2:
PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 install
Did you do:
PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 clean all
or at least
PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 clean
before you did the install step?
Or is there some environment variable set that could be interfering?
|
/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/'
Any further help appreciated! Thanks.
Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
/http://agency-software.org//
/https://agency-software.org/demo/client/
ken.tanzer@xxxxxxxxxxxxxxxxxxx <mailto:ken.tanzer@xxxxxxxxxxxxxxxxxxx>
(253) 245-3801
Subscribe to the mailing list
<mailto:agency-general-request@xxxxxxxxxxxxxxxxxxxxx?body=subscribe> to
learn more about AGENCY or
follow the discussion.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general