[caption id=”” align=”alignright” width=”64” caption=”PostgreSQL”][/caption] About a year ago I posted about installing Postgres 9.0 on my Mac. We’ll since then I lost a hard drive and am just re-installing Postgres now. This time 9.1. Here’s what I did: 1. **Download postgres for Mac**
- Don’t sign up for enterprise db crap, the download will start in a sec
2. Install postgres
- This may require reboot to set some syscontrol settings (it did for me)
- I created the “postgres” user with “postgres” as the password (so I could remember it)
3. Start postgres to create the defaults in the data directory
$ sudo su - postgres
$ . ./pg_env.sh
$ pg_ctl restart
4. Modify Postgres to use “trust” authentication, so we don’t need to supply a password when connecting to the database.
$ vi /Library/PostgreSQL/9.1/data/pg_hba.conf
4.1 For each entry, change METHOD “md5” to “trust” (this should only be done on your developer machine!) 5. Restart postgres to pick up the conf changes
$ sudo su - postgres
$ . ./pg_env.sh
$ pg_ctl restart
6. Beer time! This setup requires you to su - postgres whenever you want to restart the database, but for now it’ll work.