Re: error while installing auto_explain contrib module

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Sachin Kotwal <kotsachin(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: error while installing auto_explain contrib module
Date: 2016-04-21 14:34:21
Message-ID: 5718E4ED.5010607@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/21/2016 07:13 AM, Sachin Kotwal wrote:
>
>
> On Thu, Apr 21, 2016 at 7:20 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 04/21/2016 02:23 AM, Sachin Kotwal wrote:
>
> Hi Tom,
>
> Thanks for reply.
>
> On Tue, Apr 19, 2016 at 7:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>>> wrote:
>
> Sachin Kotwal <kotsachin(at)gmail(dot)com
> <mailto:kotsachin(at)gmail(dot)com> <mailto:kotsachin(at)gmail(dot)com
> <mailto:kotsachin(at)gmail(dot)com>>> writes:
> > On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>>
> > wrote:
> >> Did you install the 9.3.11 server from source also?
>
> > Yes. I have clone git repository and checkout for pg-9.3.11
>
> The reason for that question is that the most obvious
> explanation
> for this
> failure is that the auto_explain build is seeing a
> different value for
> PG_USE_INLINE than the main server build did.
>
>
> Ok. But I am not getting getting why auto_explain is doing that.
> All pg_config parameters have correct value as per my installation
> posted in last mail.
>
>
> Do you have a Postgres instance installed that did not come from the
> Git clone?
>
>
> Currently I do not have Postgres installation from other than Git but i
> will try that soon.
>
> I did same Postgres version installation of on CentOS 6 , It is working
> fine.

You did that as source install from the Git repo or via a package?

>
> I think it is problem with OS X. On OS X contrib tools unable to find
> correct installation paths.
> I feel we need to fix them.

I do not use OS X, so I will not be of much help there.

>
>
>
> Is it correct behaviour of auto_explain or it is bug ?
>
> So probably your include
> path is picking up a pg_config.h that does not match the
> postgres
> executable the link is happening against.
>
> regards, tom lane
>
>
> If pg_config showing following as INCLUDEDIR path
>
> INCLUDEDIR = /Users/sachin/pg_git_install/9.3.11/include
>
>
> How it can take pg_config.h from different include path?
>
> Can you tell me where i should look in auto_explain to fix this?
>
>
> --
>
> Thanks and Regards,
> Sachin Kotwal
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
>
> --
>
> Thanks and Regards,
> Sachin Kotwal

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-04-21 14:44:36 Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Previous Message Melvin Davidson 2016-04-21 14:30:44 Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created