decent postgreSQL install on OSX

Posted by Dick on August 17, 2008

public service announcement

I need a good database to run locally. When I Google for ‘postgreSQL OSX’ I see a lot of old posts that start with ‘download and build readline’. No wonder people still use MySQL.

If you’re on a Mac use EnterpriseDBs installer. It’s up to date and you get a reasonably sane default config

(everything is under /Library/PostgreSQL/8.3 if you want to tweak it).

Also bundles docs and pgAdmin (which seems to have become a half-decent tool  while I wasn’t looking) in /Applications/PostgreSQL (I found a JDBC driver under /Library/Extensions/Java too, although that could have come from anywhere).

There are also installers there for Linux (but you might as well use your package manager ) and Windows (no, really).

For production, I’d use something on a ‘real’ UNIX obviously - the Solaris 10 / SXCE bundled PostgreSQL 8.2 / 8.3 works great.

Trackbacks

Use this link to trackback from your own site.

Comments

Leave a response

  1. ketchup Sun, 31 Aug 2008 19:19:55 GMT

    Hey,
    just in case: You could use MacPorts (http://www.macports.org/) to put PostgreSQL on you Mac. That alone might not be interesting, since there is a OSX port for PostgreSQL (I gather from your post), but it might give you a hive of more traditional Unix apps you might need for serious Unix development. Like Subversion (or Git): If it’s out there as BSD port, it’s probably out there as Mac port. (Once you have it installed, use the MacPorts Notifier to stay up to date, or at least keep an eye on outdated software.)

    Have fun,
    /ketchup/

  2. Dick Mon, 01 Sep 2008 13:27:00 GMT

    Hi ketchup,

    I’m a long-time BSD fanboy, but macports is too much hassle for a lot of users and I think the EnterpriseDB option removes some hurdles.

Comments