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/
[email protected] <mailto:[email protected]>
(253) 245-3801

Subscribe to the mailing list <mailto:[email protected]?body=subscribe> to
learn more about AGENCY or
follow the discussion.


--
Adrian Klaver
[email protected]


--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to