PostgreSQL with some Jeos

September 21, 2008

PostgreSQL – Open source database (their website here).

Jeos – Stripped down Ubuntu for Virtual Machines (tutorial here).

I need a custom build of postgres because I have to get it to work with Windows Active Directory which from the literature (blogs) I have read works.  I am somewhat skeptical but PostgreSQL will be a hard sale unless it does what the literature says so I am off to test the claims.

I like to start many tests on Ubuntu’s Jeos precisely because of its stripped down nature.  I eliminate a lot of possible cruft upfront.  This present’s some problems when building software like PostgreSQL.  After following the steps in the Jeos tutorial of course it would be easy to say:

sudo apt-get install postgresql postgresql-client 

This would accomplish the task just fine but since I want a custom build it is a no go.  Just running the make script in the source distribution has issues too because PostgreSQL has more than it’s fair share of dependencies.  Enter apt’s build-dep.  Someone really thought this through for me already.  Bless you Debian and Ubuntu.  Working with tools like these is like a breath of fresh air after a day of working with the a great commercial “Enterprise” system.  It is true that people really exist who actually put thought into their products instead of a marketing website.  End Rant.  With a simple command you can get a list of dependencies that need to be built and installed for PostgreSQL (the -s means to not actually install anything, just a simulation).

sudo apt-get -s build-dep postgresql postgresql-client

Look over the list if you desire and now just take out the -s to actually do the build and install of all the dependencies that you need.

Next step, build PostgreSQL.  Coming soon.

Other Sources:

http://www.debian.org/doc/manuals/apt-howto/ch-sourcehandling.en.html

Leave a Reply