You will be using cubist because it allows cgi programs on the web. The databases backing your projects will live on cubist and will be served by a PostgreSQL server installed on cubist.
#!/bin/csh
set path = ($path /usr/local/pgsql/ /usr/local/pgsql/bin)