Re: error while installing auto_explain contrib module

On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

--

Thanks and Regards,
Sachin Kotwal