Re: Installing PostgreSQL on OSX Server

On Jan 28, 2013, at 8:47 AM, Stephen Cook <sclists(at)gmail(dot)com> wrote:

> On 1/28/2013 11:15 AM, Steve Atkins wrote:
>> You're not planning on using this in production, I hope? OS X is a very solid desktop OS, but it's server variant is packed full of weird and plain broken behaviour.
>>
>
> Ouch. These are the servers they have and use, I don't really get a say in that.
>
> Are these problems PostgreSQL-specific? They are already running Apache with PHP and MySQL on these, so if it is a general "broken-ness" I guess they are already used to it?

Not postgresql specific at all, just a lot of very flaky user-space code (and it's really just regular desktop OS X with more applications added, not really a differently tuned system). You're also going to find that it's really poorly suited for remote management via ssh, and the remote management apps have ridiculous OS version requirements for the management console. Plan on setting up VNC or using screen sharing (which is available on OS X client, /System/Library/CoreServices/Screen Sharing.app, or something like that).

If they're already using them in production with apache/php, nothing they're doing should break when they switch to postgresql.

Cheers,
Steve