Converted development to PostgreSQL today. https://github.com/puppetlabs/puppetlabs-postgresql - change puppet config for connecting with pgAdmin3 https://devcenter.heroku.com/articles/heroku-postgresql#local-setup

handy commands:

sudo cp /etc/postgresql/9.1/main/postgresql.conf .
sudo cp postgresql.conf /etc/postgresql/9.1/main/postgresql.conf


sudo cp /etc/postgresql/9.1/main/pg_hba.conf .
sudo cp pg_hba.conf /etc/postgresql/9.1/main/

sudo service postgresql restart

#postgresql