At the moment I'm running MAMP Pro, but the setup should work with MAMP free version as well.
Download and install MAMP from MAMP
- Download and install postgres 8.4 or higher from Enterprise DB
- Add the bin directory of postgres, /Library/PostgreSQL/8.4/bin to the PATH in your .bashrc file in your home directory. Remember to run ./.bashrc to update the path.
- Sudo to your root user and execute the following commands. '>' is the prompt on your terminal and should be excluded. Text in () is an explanation and should not excluded.
- > su postgres (log in as the postgres user)
- > createuser --no-createdb --no-password (choose as a super user)
- > createuser --no-createdb ----pwprompt devel (enter a password 'drupal', and choose as a super user, this is if your site is using the standard devel user with password drupal)
- > exit
- Edit table at the bottom of the /Library/PostgreSQL/8.4/data/pg_hba.conf file to so that the options for local look like this. This states that the devel (or your user) must have a md5 password and all other users can log in with no password. (This is only recommended for your local host and is not secure on a server)
# "local" is for Unix domain socket connections only
local all devel md5
local all all trust
- In your applications folder stop and start the postgres server using the apps under the Postgres folder
- Log out of your root user
- Create your postgres database as specified in INSTALL.pgsql.txt:
- > createdb --encoding=UTF8 --owner=username databasename (The owner is devel or the user you created)