EnterpriseDB maintains a Mac OS X binary installer. First, download and install from here:
http://www.enterprisedb.com/products-services-training/pgdownload#osx
The package will take care of most of the PostgreSQL installation needs but it needs a couple of small tweaks.
Become the new postgres user that the package added:
sudo su - postgres
Source the environment file:
source pg_env.sh
Next, setup postgres to listen on TCP/IP sockets. Edit $PGDATA/postgresql.conf and listen_addresses is set to ‘localhost’.
Also, for a more convenient development server setup, it is nice to loosen the host-based security settings for localhost. Edit $PGDATA/pg_hba.conf and set the local and 127.0.0.1/32 lines to use “trust” authentication (change the last column from md5 to trust).
Lastly, apply the changes using pg_ctl reload and exit to log out as the postgres user.
Now you should be able to access postgres using psql -U postgres. Create a new database using createdb -U postgres opencomparison.
If you prefer to use Homebrew to install your software you can do this:
brew install postgresql
initdb /usr/local/var/postgres -E utf8
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
Change the path used in initdb and other commands if you’d rather store your data files somewhere other than /usr/local/var/postgres.
Once the server is started, execute:
createdb opencomparison
Then you should be able to access the database you created via psql so:
psql --dbname opencomparison
Remeber to shut down the service when not in use:
pg_ctl -D /usr/local/var/postgres stop
The security defaults are already in place, and will allow a lot of access. This should never be considered a production-ready deployment scenario.
Install Postgres 8.4 (the version used on the site, as of this writing) with:
sudo apt-get install postgresql-8.4 libpq-dev
Edit /etc/postgresql/8.4/main/postgresql.conf and make sure the listen line is either listen = 'localhost' or listen = '*' to listen on all interfaces.
Also, for a more convenient development server setup, it is nice to loosen the host-based security settings for localhost. Edit /etc/postgresql/8.4/main/pg_hba.conf and set the local and 127.0.0.1/32 lines to use “trust” authentication (change the last column from md5 to trust).
Apply those changes with /etc/init.d/postgresql-8.4 reload.
Lastly, create a new database using createdb -U postgres opencomparison.
EnterpriseDB maintains a Windows binary installer. First, download and install from here:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
The package will take care of most of the PostgreSQL installation needs but it needs a couple of small tweaks.
Install the Windows port of psycopg2 from http://www.stickpeople.com/projects/python/win-psycopg/
Open pgAdmin III. Right-click on PostgreSQL 8.4 (localhost:5432) and choose Connect. Enter the Postgres user password.
Right-click Databases and choose New Database. Give it the name opencomparison and the owner postgres. Click OK.