Missing path in pg_config

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

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/

It sounds like I'm in quite a fix here. If PGXS is currently a no-go in Windows, then that renders the temporal extension incompatible 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 extension installed, I'd be grateful if someone could help me along with it (further to your below suggestions, since I'm floundering 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/

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 extension incompatible 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 extension installed, I'd be grateful if someone could help me along with it (further to your below suggestions, since I'm floundering 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/