PostgreSQL Basics by Example

Re:PostgreSQL Basics by Example by chourobin on Sunday August 18, 2013 @09:37PM (#6235118)

As much I like mattt's work, I dont understand, why is this needed. brew install postgres is just as easy and in my experience Postgres.app is not well maintained and uses an older version.

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by southpolesteve on Sunday August 18, 2013 @09:57PM (#6235175)

I've personally helped 4 people setup Postgres on a recent model macbook with OSX Mountain Lion for Rails dev in the last 6 months. Every one has been terrible. Issue with sockets, issues with file permissions, issues with previous attempted installs, issues with setting up database users. Postgres.app just works and it is awesome.

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by chourobin on Sunday August 18, 2013 @10:05PM (#6235191)

Thats interesting, I've never had an issue with the homebrew installation. The readme details 1 or 2 lines to get everything set up for the first time.

I suppose osx built-in installation may cause conflicts.

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by misiti3780 on Sunday August 18, 2013 @11:00PM (#6235383)

here is the one I was having,

http://stackoverflow.com/questions/12472988/postgres-could-n...

postgres app fixed it

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by skndr on Sunday August 18, 2013 @10:12PM (#6235221)

> I suppose osx built-in installation may cause conflicts.

This is a consistent source of trouble when installing Postgres. Usually, this involves looking up the right places to modify the path and sometimes needing to change permissions/ports.

[ Parent | on HN ]

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 ]

Re:PostgreSQL Basics by Example by superdude on Monday August 19, 2013 @12:14AM (#6235586)

Postgres.app uses the latest stable version of Postgres (9.2.4), so I don't know what you mean.

http://postgresapp.com/

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by eddieroger on Monday August 19, 2013 @09:05AM (#6236963)

Not everyone is comfortable with the command line, so this is great for people like them. Also, and it may be isolated to me, but my brew formulae get screwed up all the time, and it's a decent sized challenge to get back to working if you're only a git novice. And sometimes, all you need is Postgres, and not the overhead of brew. No sense introducing stuff you don't need.

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by mason55 on Monday August 19, 2013 @10:10AM (#6237281)

> Not everyone is comfortable with the command line, so this is great for people like them.

This is probably "elitist" of me but I feel like someone who isn't comfortable with the command line should be learning that before they tackle Postgres.

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by misiti3780 on Sunday August 18, 2013 @10:59PM (#6235376)

i have had multiple problems with brew install postgres. it installs the code just fine but you get weird errors when trying to start the server and connect to it with the psql client

[ Parent | on HN ]

Re:PostgreSQL Basics by Example by hackerboos on Monday August 19, 2013 @09:40AM (#6237106)

It's a pain to upgrade using this.

[ Parent | on HN ]