GNU Readline
library (means you have a command history in the interactive "psql" interpreter,
use the up and down keys)
JDBC drivers (in /usr/local/pgsql/share/java)
ODBC
C++
After installing, do this (with administrator rights):
Create a new user in the "Users" System Prefs pane:
Name: "PostgreSQL User"
Short Name: "postgres"
Password: whatever you want
Open a terminal window and type in the following commands (without the double quotes):
type "sudo chown -R postgres /usr/local/pgsql/", enter administrator password when asked
type "su - postgres", enter the password of the newly created postgres user when asked
type "initdb -D /usr/local/pgsql/data" and wait for the operation to complete
type "sh -c 'postmaster -D /usr/local/pgsql/data > logfile 2>&1 &'" (the single quotes are important)
Now you can create a test database with "createdb test"
Use it with "psql test"
If you would like PostgreSQL to start up automatically when the system comes up,
then you can install the package which installs a StartupItem into "/Library/StartupItems" above.