Getting "connectby" installed

Hi,

I'm trying to get the "connectby" function installed, but not getting
very far. The root problem is that I didn't really "install" pgsql
originally, but used an RPM - as such I have no real idea how to modify
the existing installation. I'm running Mandrake 9.1.

I'm guessing the first thing I have to do is get hold of the postgresql
source, as I don't appear to have it at the moment. However, then I
have the problem of rebuilding postgre - I'm slightly nervous about
either losing the existing databases or somehow "breaking" the
relationship between php / apache and postgre - is there an idiot's
guide to this sort of thing? As an example of my current ignorance, I'm
not even sure where postgre is installed at the moment!

Once I've worked out how to reinstall pgsql without breaking
everything, it looks like installing the "connectby" function should be
fairly easy, but that first step is currently stalling me...

Cheers,

Tim.