Postgres Now the Default Database for Mac OS X Server

The site is timing out for me right now.<p>Still, whatever the reason for the switch (is Oracle involved?), this seems like a good new default.<p>I've found Postgres capable, fast, and rock-solid. (At the point I switched from MySQL, a few years ago, I'd be tempted to say that it had approximately none of those three going for it. I'll be happy to hear that MySQL has improved meanwhile, though: is there any particular reason I might consider switching back?).

Congrats to the Postgres guys. Even if this is for primarily licensing reasons, pgsql is a solid, powerful database that's easily more powerful than MySQL, and is slowly making gains against Oracle. It's underused, and lacking in name recognition, but hopefully this is the first step towards changing that.

It will be interesting how a discussion (if there is one) on Hacker News will differ from Reddit. There the forty comments did fall in two categories:<p>1. There is a Server Version?<p>2. It is spelled OS X without a slash.

Having upgraded to Lion Server on one of my boxes, I found that Postgres was indeed running. Or at least trying to run. It seems that the permissions weren't set properly on the conf file or data directories, so my log was filling up with "failure to start" messages as it tried to launch Postgres every 10 seconds. Even a "repair permissions" failed to solve the problem, and I had to manually go in and change some ownerships from the root user to _postgres.<p>Not sure if this is just my issue, but if you did upgrade to Server, you might want to check your system's log file.

I take this as great news. Postgres is my preferred SQL database. I wish I could articulate better why I don't like MySQL as much, but it just feels 'strange' in comparison.

As a nice perk, all of the core client binaries [0] (and pg_upgrade [1]) are already present without having Mac OS X Server installed.<p>That includes: clusterdb, createdb, createlang, createuser, dropdb, droplang, dropuser, ecpg, pg_config, pg_dump, pg_dumpall, pg_restore, pg_upgrade, psql, reindexdb, and vacuumdb.<p>Unfortunately, it doesn't include any of the server binaries: initdb, pg_controldata, pg_ctl, pg_resetxlog, postgres, or postmaster.<p>For the curious, I've pasted the output of pg_config at <a href="http://www.pastie.org/2275197" rel="nofollow">http://www.pastie.org/2275197</a><p>[0]: <a href="http://www.postgresql.org/docs/9.0/static/reference-client.html" rel="nofollow">http://www.postgresql.org/docs/9.0/static/reference-client.h...</a><p>[1]: <a href="http://www.postgresql.org/docs/9.0/static/pgupgrade.html" rel="nofollow">http://www.postgresql.org/docs/9.0/static/pgupgrade.html</a>

I was under the impression that Apple was discontinuing their XServe product line after Jan 31st 2011. If this is the case, what hardware are people running OS X Server on? <a href="http://www.macworld.com/article/155483/2010/11/xserve_discontinued.html" rel="nofollow">http://www.macworld.com/article/155483/2010/11/xserve_discon...</a>

does this mean we'll get a better osx gui for interacting with postgres? all i could find is navicat and it kind of suck.

Anyone any idea what version they're using?