Thread: Missing path in pg_config

Missing path in pg_config

From
"Turner, John J"
Date:

Hello,

Ive installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and Im trying to install the temporal extension module available in pg_Foundry.  One problem I can see that Im running into is that the path defined for PGXS in pg_config does not exist:

PGXS = c:/program files/PostgreSQL/9.0/lib/pgxs/src/makefiles/pgxs.mk

I have a path up to the /lib but nothing after that.  Do I need to re-install something or run a script to flesh things out?

It seems when I follow the instructions for the temporal module install (as found here), it bombs out when it tries to find this path while running make install

Any help greatly appreciated.

Thanks,

John

Re: Missing path in pg_config

From
Dave Page
Date:
On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J
<JJTurner@statestreet.com> wrote:
> Hello,
>
> I’ve installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and
> I’m trying to install the temporal extension module available in
> pg_Foundry.  One problem I can see that I’m running into is that the path
> defined for PGXS in pg_config does not exist:
>
> PGXS = c:/program files/PostgreSQL/9.0/lib/pgxs/src/makefiles/pgxs.mk
>
> I have a path up to the “…/lib” but nothing after that.  Do I need to
> re-install something or run a script to flesh things out?
>
> It seems when I follow the instructions for the temporal module install (as
> found here), it bombs out when it tries to find this path while running make
> install

PGXS doesn't work with the VC++ build we use for Windows. I wonder if
that output from pg_config should be #ifdef'd out until such time as
we can figure out a way to make it work - if that's even possible.



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

Re: Missing path in pg_config

From
Magnus Hagander
Date:
On Thu, Sep 30, 2010 at 00:55, Dave Page <dpage@pgadmin.org> wrote:
> On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J
> <JJTurner@statestreet.com> wrote:
>> Hello,
>>
>> I’ve installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and
>> I’m trying to install the temporal extension module available in
>> pg_Foundry.  One problem I can see that I’m running into is that the path
>> defined for PGXS in pg_config does not exist:
>>
>> PGXS = c:/program files/PostgreSQL/9.0/lib/pgxs/src/makefiles/pgxs.mk
>>
>> I have a path up to the “…/lib” but nothing after that.  Do I need to
>> re-install something or run a script to flesh things out?
>>
>> It seems when I follow the instructions for the temporal module install (as
>> found here), it bombs out when it tries to find this path while running make
>> install
>
> PGXS doesn't work with the VC++ build we use for Windows. I wonder if
> that output from pg_config should be #ifdef'd out until such time as
> we can figure out a way to make it work - if that's even possible.

I don't know pgxs internals well enough, but would it work if we just
shipped the pgxs file - for users of mingw? I have a feeling it won't
- the thing uses files generated by the postgresql ./configure-script,
doesn't it?


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Missing path in pg_config

From
"Turner, John J"
Date:
It sounds like I'm in quite a fix here.  If PGXS is currently a no-go in Windows, then that renders the temporal
extensionincompatible with Windows since it uses PGXS to install... 

OTOH, if there's some remote possibility of some workaround solution for Windows to get PGXS and/or the temporal
extensioninstalled, I'd be grateful if someone could help me along with it (further to your below suggestions, since
I'mfloundering around in unfamiliar territory here). 


-----Original Message-----
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Thursday, September 30, 2010 4:35 AM
To: Dave Page
Cc: Turner, John J; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Missing path in pg_config

On Thu, Sep 30, 2010 at 00:55, Dave Page <dpage@pgadmin.org> wrote:
> On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J
> <JJTurner@statestreet.com> wrote:
>> Hello,
>>
>> I've installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and
>> I'm trying to install the temporal extension module available in
>> pg_Foundry.  One problem I can see that I'm running into is that the path
>> defined for PGXS in pg_config does not exist:
>>
>> PGXS = c:/program files/PostgreSQL/9.0/lib/pgxs/src/makefiles/pgxs.mk
>>
>> I have a path up to the ".../lib" but nothing after that.  Do I need to
>> re-install something or run a script to flesh things out?
>>
>> It seems when I follow the instructions for the temporal module install (as
>> found here), it bombs out when it tries to find this path while running make
>> install
>
> PGXS doesn't work with the VC++ build we use for Windows. I wonder if
> that output from pg_config should be #ifdef'd out until such time as
> we can figure out a way to make it work - if that's even possible.

I don't know pgxs internals well enough, but would it work if we just
shipped the pgxs file - for users of mingw? I have a feeling it won't
- the thing uses files generated by the postgresql ./configure-script,
doesn't it?


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Missing path in pg_config

From
Magnus Hagander
Date:
On Thu, Sep 30, 2010 at 17:45, Turner, John J <JJTurner@statestreet.com> wrote:
>
> It sounds like I'm in quite a fix here.  If PGXS is currently a no-go in Windows, then that renders the temporal
extensionincompatible with Windows since it uses PGXS to install... 

It's not entirely a no-go. If you really want it, you could download
and build postgresql using mingw. That will give you the pgxs files to
build it with. Yes, it's a really hard and painful way to do it, but
it can be done :-)


> OTOH, if there's some remote possibility of some workaround solution for Windows to get PGXS and/or the temporal
extensioninstalled, I'd be grateful if someone could help me along with it (further to your below suggestions, since
I'mfloundering around in unfamiliar territory here). 

I wonder how hard it would be to make MSVC build files for the
temporal extensions. IIRC it's a very simple project. Jeff - have you
looked at this?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/