Lincoln Stoll

EnterpriseDB have done some reshuffling, and have release a package called Postgres Plus - contains their tweaked version of postgresql bundled with some other pieces for a bunch of platforms including mac - well recommended.

I did have a few problems getting the postgres gem working with it - here’s what I had to do

*Mac OS X:*

1
2

PATH=$PATH:/Library/PostgresPlus/8.3/bin/
sudo gem install postgres -- --with-pg-include=/Library/PostgresPlus/8.3/include --with-pg-lib=/Library/PostgresPlus/8.3/lib/ ARCHFLAGS='-arch i386'

*Linux:*

1
2
3
4

PATH=$PATH:/Library/PostgresPlus/8.3/bin/
sudo ln -s /usr/lib/libssl.so.0.9.8 /usr/lib/libssl.so.4
sudo ln -s /usr/lib/libcrypto.so.0.9.8 /usr/lib/libcrypto.so.4
sudo gem install postgres -- --with-pg-include=/Library/PostgresPlus/8.3/include --with-pg-lib=/Library/PostgresPlus/8.3/lib

You’ll probably want to make the PATH change permanent for access to psql.

And that should get you going. Those of you who use postgres should definately check it out at “http://www.enterprisedb.com/”:http://www.enterprisedb.com/ - and for those using any other DB it’s worth checking out too.