Last updated February 13, 2012. Created by diricia on February 13, 2012.
Log in to edit this page.
At the moment I'm running MAMP Pro, but the setup should work with MAMP free version as well.
Requirments;
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)