Re: Installing PostgreSQL on OSX Server - Mailing list pgsql-general

From Steve Atkins
Subject Re: Installing PostgreSQL on OSX Server
Date
Msg-id CC589436-9A19-4D40-A18C-B952D5B16ACE@blighty.com
Whole thread Raw
In response to Re: Installing PostgreSQL on OSX Server  (Stephen Cook <sclists@gmail.com>)
List pgsql-general
On Jan 28, 2013, at 8:47 AM, Stephen Cook <sclists@gmail.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
packedfull 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
withmore applications added, not really a differently tuned system). You're also going to find that it's really poorly
suitedfor remote management via ssh, and the remote management apps have ridiculous OS version requirements for the
managementconsole. Plan on setting up VNC or using screen sharing (which is available on OS X client,
/System/Library/CoreServices/ScreenSharing.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

pgsql-general by date:

Previous
From: Stephen Cook
Date:
Subject: Re: Installing PostgreSQL on OSX Server
Next
From: Kevin Grittner
Date:
Subject: Re: Best approach for query with optional constraints