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.
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/
August 31, 2008 @ 7:19 pm
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.
September 1, 2008 @ 1:27 pm