Keith Watanabe * NET 2.0

You can put this into a shell script and run it: ./configure --prefix=/opt/databases/postgres7.4.2 --enable-locale --enable-multibyte=UNICODE --with-odbc --with-java --with-perl --with-python --with-tcl make make install all the --with-* style flags are what i tend to use. make sure that you have certain software setup when you do this such as java and tcl! Java additionally requires ant. So you need to have the ant binary in your $PATH. tcl requires additional libraries for the client software program. If you're running Redhat, make sure you install those tcl rpms. I use apt-get from freshrpms.net to avoid the headaches of dependencies. From there, if you want to get it started, here's a few additional steps: # adduser pgsql # mkdir /opt/databases/pgsql/data # chown pgsql /opt/databases/pgsql/data # su - pgsql # /opt/databases/pgsql/bin/initdb -D /opt/databases/pgsql/data -S That last commands puts the server into a daemon mode and forks it into the background.