PostgreSQL RDBMS for OS X V7.1.x
A Free Full featured enterprise SQL databse for UNIX

Project Source code pages
The PostgreSQL RDBMS for OS X Home Page
Mac OS X package built by Marc Liyanage
Please READ ALL this page BEFORE installing the packages!
Meta Package Download PostgreSQL DBMS 7.1.2+Startup script and, Perl Interface:
PostgreSQLComplete
Seperate Packages:
PostgreSQL DBMS 7.1
PostgreSQL DBMS 7.1.2
PostgreSQL DBMS 7.1.3
PostgreSQL Startup Scripts
PostgreSQL Perl Interface
PHP-Admin Interface V2.2.1.p1

This version is built with support for:

After installing, do this (with administrator rights):

  1. Create a new user in the "Users" System Prefs pane:
    1. Name: "PostgreSQL User"
    2. Short Name: "postgres"
    3. Password: whatever you want
  2. Open a terminal window and type in the following commands (without the double quotes):
  3. type "sudo chown -R postgres /usr/local/pgsql/", enter administrator password when asked
  4. type "su - postgres", enter the password of the newly created postgres user when asked
  5. type "initdb -D /usr/local/pgsql/data" and wait for the operation to complete
  6. type "sh -c 'postmaster -D /usr/local/pgsql/data > logfile 2>&1 &'" (the single quotes are important)
  7. Now you can create a test database with "createdb test"
  8. 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.