PostgreSQL in Server only?

Discussion in 'Mac OS X Lion (10.7)' started by altecXP, Aug 21, 2011.

  1. altecXP macrumors 65816

    Joined:
    Aug 3, 2009
    #1
    I know that mySQL was in both Client and Server. Has SQL been moved to only Server?
     
  2. mrapplegate macrumors 68030

    Joined:
    Feb 26, 2011
    Location:
    Cincinnati, OH
    #2
    Yes, the server default is now PostgreSQL.


    http://support.apple.com/kb/HT4828
     
  3. altecXP thread starter macrumors 65816

    Joined:
    Aug 3, 2009
    #3
    Thats not that I mean. MySQL used to be in both Client and Server OS X, is PostgreSQL still in Client, or is it only in Server now?
     
  4. mrapplegate macrumors 68030

    Joined:
    Feb 26, 2011
    Location:
    Cincinnati, OH
    #4
    It looks like it is only in the server.
    http://apple.stackexchange.com/questions/19209/postgresql-in-os-x-lion
    http://johnmccombs.inmap.net/2011/08/07/osx-lion-and-postgresql/

    More info.
    http://www.kyngchaos.com/blog/2011/20110730_lion_first_pass
    You can fix your Postgres installation with these commands in a Terminal:
    sudo chown -R _postgres:_postgres /usr/local/pgsql-9.0/data
    sudo chown -R _postgres:admin /usr/local/pgsql-9.0/var
    sudo dscl . -delete /Groups/postgres
    Then edit /Library/LaunchDaemons/org.postgresql.postgres.plist and change the UserName string to:
    _postgres
    Now reload the launch daemon: (or simply restart your Mac)
    sudo launchctl unload /Library/LaunchDaemons/org.postgresql.postgres.plist
    sudo launchctl load /Library/LaunchDaemons/org.postgresql.postgres.plist
    Installers should all work, except that Postgres won't start. Just apply the above fix after installing and you should be good to go. I'll have a fixed installer out soon.
     

Share This Page