You can use the Fink package system to install postgresql if you
are already using Fink (inside a terminal:
install postgresql and then configure the server).
OR you can install postgresql, with the clean solution offered by Marc Liyanage.
I prefer the 2nd option. If you also choose that, follow carefully the installation instructions and you'll have PgSQL working in minutes.