Log in

No account? Create an account
PostGreSQL xml extensions (pgxml / xml2) now much easier on windows - Nick [entries|archive|friends|userinfo]

[ website | gagravarr.org ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

PostGreSQL xml extensions (pgxml / xml2) now much easier on windows [Jul. 30th, 2009|03:23 pm]
At work, we make quite heavy use of the contrib xml2 xml parsing functions in PostGreSQL (just a shame they're not in 8.4 as standard....). On linux, getting the module compiled in is fairly easy, and has been since 8.0. On windows, it used to be a bit of a faff.

I upgraded the first of our windows machines to postgresql 8.3 the other day, and start out with the usual process of part building under mingw / msys, then building just the module with mingw (see this for more details). The good news is that this method seems to work fine still. What's more, installing MinGW and MSYS has got quite a lot easier in the last couple of years :)

The even better news is that the binary windows downloads of postgresql 8.3 seem to come with the pgxml / xml2 contrib functions pre-built :)

For anyone still on PostGreSQL 8.0 or 8.1 on windows, you can download pre-built pgxml modules from http://encore.torchbox.com/pgxml/.