README.windows

= Compiling on MS Windows

In order to build this extension on MS Windows you will need a couple things.

First, a compiler. For the one click installer this means you should either
use VC++ 6.0 or the compiler that comes with cygwin or mingw if you're
building on that platform.

If you've built Ruby yourself, you should use the same compiler to build
this library that you used to build Ruby.

Second, PostgreSQL. Be sure you installed it with the development header
files if you installed it using the standard PostgreSQL installer for
Windows. If you didn't, you can run the installer again, select "modify",
and then select the 'development headers' option to install them.

I recommend making sure that 'pg_config.exe' is in your PATH. The PostgreSQL
installer for Windows does not necessarily update your PATH when it installs
itself, so you may need to do this manually. This isn't strictly necessary,
however.

In order to build ruby-pg, just run 'rake'. If the pg_config.exe executable
is not in your PATH, you'll need to explicitly point ruby-pg to where your
PostgreSQL headers and libraries are with something like this:

   rake --with-pg-dir=c:/progra~1/postgr~1/8.3

Adjust your path accordingly. BE SURE TO USE THE SHORT PATH NAMES! If you
try to use a path with spaces in it, the nmake.exe program will choke.


== Cross compiling for mswin32

Using rake-compiler a cross compiled pg-gem can be build on a linux host for
the win32 platform. The generated gem is statically linked against libpq and
libssl. OpenSSL and PostgreSQL are downloaded and compiled from the sources.
There are no runtime dependencies to any but the standard Windows DLLs.

Install mingw32. On a debian based system this should work:

   apt-get install mingw32

On MacOS X, if you have MacPorts installed:

  port install i386-mingw32-gcc

Install the rake-compiler:

  gem install rake-compiler

Download and cross compile ruby for win32:

  rake-compiler cross-ruby VERSION=1.8.6-p287

Download and cross compile pg for win32:

  rake cross native gem RUBY_CC_VERSION=1.8.6 OPENSSL_VERSION=0.9.8l POSTGRESQL_VERSION=8.4.2

If everything works, there should be pg-VERSION-x86-mswin32.gem in the pkg
directory.


If you have any problems you can submit them via the project's issue-tracker:

  http://bitbucket.org/ged/ruby-pg/issues/new/

Or you can join the mailing list:

  ruby-pg-general@rubyforge.org

And submit questions, problems, or solutions, so that it can be improved.