On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 04/18/2016 11:46 PM, Sachin Kotwal wrote: > >> Hi, >> >> I am trying to install auto_explain on PostgreSQL-9.3.11 >> OS X EI Capitan - 10.11 >> > > Did you install the 9.3.11 server from source also? Yes. I have clone git repository and checkout for pg-9.3.11 > > >> >> I am getting following error: >> >> ------ >> $ pwd >> /Users/sachin/postgres_git/postgres/contrib/auto_explain >> > > What version of Postgres is the above pointing to? This is my postgres git repository and i have checkout for pg-9.3.11 So above is pointing to auto_explain directory under contrib for same postgres version. Here is my pg_config output: ----- $ pg_config BINDIR = /Users/sachin/pg_git_install/9.3.11/bin DOCDIR = /Users/sachin/pg_git_install/9.3.11/share/doc/postgresql HTMLDIR = /Users/sachin/pg_git_install/9.3.11/share/doc/postgresql INCLUDEDIR = /Users/sachin/pg_git_install/9.3.11/include PKGINCLUDEDIR = /Users/sachin/pg_git_install/9.3.11/include/postgresql INCLUDEDIR-SERVER = /Users/sachin/pg_git_install/9.3.11/include/postgresql/server LIBDIR = /Users/sachin/pg_git_install/9.3.11/lib PKGLIBDIR = /Users/sachin/pg_git_install/9.3.11/lib/postgresql LOCALEDIR = /Users/sachin/pg_git_install/9.3.11/share/locale MANDIR = /Users/sachin/pg_git_install/9.3.11/share/man SHAREDIR = /Users/sachin/pg_git_install/9.3.11/share/postgresql SYSCONFDIR = /Users/sachin/pg_git_install/9.3.11/etc/postgresql PGXS = /Users/sachin/pg_git_install/9.3.11/lib/postgresql/pgxs/src/makefiles/ pgxs.mk CONFIGURE = '--with-libxml' '--enable-cassert' '--enable-debug' '--enable-profiling' '--prefix=/Users/sachin/pg_git_install/9.3.11/' '--with-python' 'CFLAGS=-g -O0' CC = gcc CPPFLAGS = -I/usr/include/libxml2 CFLAGS = -g -O0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -g -pg CFLAGS_SL = LDFLAGS = -L../../../src/common -Wl,-dead_strip_dylibs LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgport -lpgcommon -lxml2 -lz -lreadline -lm VERSION = PostgreSQL 9.3.11 ---- > > >> $ make >> gcc -g -O0 -Wall -Wmissing-prototypes -Wpointer-arith >> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute >> -Wformat-security -fno-strict-aliasing -fwrapv >> -Wno-unused-command-line-argument -g -pg -I. -I. -I../../src/include >> -I/opt/local/include/libxml2 -c -o auto_explain.o auto_explain.c >> gcc -g -O0 -Wall -Wmissing-prototypes -Wpointer-arith >> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute >> -Wformat-security -fno-strict-aliasing -fwrapv >> -Wno-unused-command-line-argument -g -pg -bundle -multiply_defined >> suppress -o auto_explain.so auto_explain.o -L../../src/port >> -L../../src/common -L/opt/local/lib -Wl,-dead_strip_dylibs >> -bundle_loader ../../src/backend/postgres >> ld: warning: directory not found for option '-L/usr/local/lib' >> Undefined symbols for architecture x86_64: >> "_MemoryContextSwitchTo", referenced from: >> _explain_ExecutorStart in auto_explain.o >> ld: symbol(s) not found for architecture x86_64 >> clang: error: linker command failed with exit code 1 (use -v to see >> invocation) >> make: *** [auto_explain.so] Error 1 >> >> >> -- >> >> Thanks and Regards, >> Sachin Kotwal >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Thanks and Regards, Sachin Kotwal
