PostgreSQL Basics by Example

Re:PostgreSQL Basics by Example by darthdeus on Monday August 19, 2013 @06:04AM (#6236387)

To be honest I've spent about 4 hours last week trying to install homebrew PostgreSQL on a friends MacBook ... it took me forever to figure out why it wasn't connecting to the right socket, just because he had some things out of date :\

While it is really easy to install most of the time, I'd say the Postgres.app works well for people who aren't developers but need to use PostgreSQL.

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by chourobin on Monday August 19, 2013 @10:37AM (#6237438)

Did you see the post installation instructions to initialize a db?

initdb /usr/local/var/postgres -E utf8

Also if you are working with rails, add host: localhost in your database.yml file and remove the user password. That should be all you need.

[ Parent | on HN ]