Thread: Missing path in pg_config
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
Any help greatly appreciated.
Thanks,
John
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 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/
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/