You can use the Fink package system to install postgresql if you are already using Fink (inside a terminal:
sudo fink install postgresql and then configure the server).
I prefer the 2nd option. If you also choose that, follow carefully the installation instructions and you'll have PgSQL working in minutes.
If you'd like to have 2 scripts for manually starting and stoping the database create the files:
Starting script (pgstart.sh)
su postgres -c "/usr/local/bin/pg_ctl -D /usr/local/pgsql/data -l ~/postgres.log start" (line wrapped)
Stop script (pgstop.sh)
su postgres -c "/usr/local/bin/pg_ctl -D /usr/local/pgsql/data stop" You need execute permissions in these scripts [by
chmod 755 pgstart.sh pgstop.sh] and you can invoke them with
./pgstart.sh commands within the terminal. Note that the postgres password will be prompted.