regoli
Level 1 (10 points)

Q: Lion Server to Mavericks Server Update: missing postgres config file

Hello!  I just upgraded from OS X Lion Server to Mavericks with Server 3.0.  I don't use a lot of postgres services but I notice that there are these in my System log:

 

servermgr_postgres_server: missing postgres config file: /Library/Server/PostgresSQL for Server Services/Config/com.apple.postgres.plist

 

Checking the status of postgres, no surprise:

 

sudo /Applications/Server.app/Contents/ServerRoot/usr/sbin/serveradmin status postgres

postgres:state = "STOPPED"

 

I know Apple is working to concentrate all server like items under /Library/Server/{service} but is this a bug in the installer? Postgres was running under Lion Server—and it looks like everything is still in /etc/postfix—but apparently the settings didn't get completely migrated?

 

In /Library/Server/PostgresSQL/Config I have one file: org.postgresql.postgres.plist

 

Any ideas on how to make this configuration correct again? Thanks!  —michael

Mac mini, OS X Server, Server

Posted on Nov 8, 2013 5:58 AM

by Trismegister,Solvedanswer
Trismegister Trismegister
Level 1 (22 points)
Servers Enterprise
A:

Yes, thanks @regoli, Server 3.0.1 seems to have addressed this and one or two other problems.

The system log is still far too noisy .... but all the services we use seem to be working just fine.

Posted on Nov 21, 2013 2:32 PM

Close
regoli

Q: Lion Server to Mavericks Server Update: missing postgres config file

  • All replies
  • Helpful answers

  • by Trismegister,

    Trismegister Trismegister Nov 8, 2013 4:39 PM in response to regoli
    Level 1 (22 points)
    Servers Enterprise
    Nov 8, 2013 4:39 PM in response to regoli

    I also just upgraded but from OS X Mountain Lion and Server 2 to Mavericks with Server 3 and I also get this "missing postgress config file" but, unlike you, postgres:state = "RUNNING"

     

    My symptoms are that Time Machine cannot take a backup as it logs errors "ServerBackup[1532]: Error in calling backup command for service postgresql, error :=-1"

     

    Just seen that others report the same problem as mine here

     

    Message was edited by: Trismegister

  • by regoli,

    regoli regoli Nov 21, 2013 1:52 PM in response to regoli
    Level 1 (10 points)
    Nov 21, 2013 1:52 PM in response to regoli

    Just to follow-up: The upgrade to 3.0.1 of OS X Server seems to have taken care of this problem of no active Postgres processes running on the machine.

     

    @Trismegister, you should run the OS X Server 3 upgrade — which seems to be almost exclusively for folks like us who upgraded to Mavericks from Lion. 

     

    For more, see http://support.apple.com/kb/HT6043

     

    —michael

  • by Trismegister,Solvedanswer

    Trismegister Trismegister Nov 21, 2013 2:32 PM in response to regoli
    Level 1 (22 points)
    Servers Enterprise
    Nov 21, 2013 2:32 PM in response to regoli

    Yes, thanks @regoli, Server 3.0.1 seems to have addressed this and one or two other problems.

    The system log is still far too noisy .... but all the services we use seem to be working just fine.

  • by mlorim,

    mlorim mlorim Mar 7, 2014 8:43 AM in response to Trismegister
    Level 1 (5 points)
    Mar 7, 2014 8:43 AM in response to Trismegister

    I had the same error message in the logs, using Server v3.0.3.

     

    sudo /applications/server.app/contents/serverroot/usr/sbin/serveradmin status postgres

     

    responded as "STOPPED"

     

    Without changing or adding any files I tried

    sudo /applications/server.app/contents/serverroot/usr/sbin/serveradmin start postgres

     

    and progres:state responded "RUNNING"

     

    The log errors stopped appearing.

  • by mlorim,

    mlorim mlorim Mar 12, 2014 11:35 AM in response to mlorim
    Level 1 (5 points)
    Mar 12, 2014 11:35 AM in response to mlorim

    Scratch that. With Postgres state "Running", the same error is recurring.

     

    :missing postgres config file: /Library/Server/PostgreSQL For Server Services/Config/com.apple.postgres.plist

     

    Still looking, and investigating a PostgreSQLClient permissions error writing to wiki.

     

    Mavericks 10.9.2

    Server 3.0.3

  • by regoli,

    regoli regoli Mar 12, 2014 5:26 PM in response to regoli
    Level 1 (10 points)
    Mar 12, 2014 5:26 PM in response to regoli

    Thanks for all the feedback to this thread. It's clear that the "upgrade" from Lion Server to Mavericks (and then Mavericks Server) leads MUCH to be desired.

     

    I am hobbling along since November (when the Mavericks update came out) until I can completely reinstall the OS from scratch.

     

    There are too many anomalies that happened when upgrading that trying to solve these glitches—without having a clean "install" as a foundation—is a complete waste of time.

     

    Unfortunately Apple really didn't pave the OS X Lion Server to OS X Mavericks Server path very smoothly.  —michael

  • by Robb Allan,

    Robb Allan Robb Allan Mar 25, 2014 4:08 PM in response to regoli
    Level 2 (354 points)
    Servers Enterprise
    Mar 25, 2014 4:08 PM in response to regoli

    sudo -s

    ln -s /Library/Server/Postgres/Config /Library/Server/Postgres\ For\ Server\ Services/Config

    ln -s /Library/Server/Postgres/Data /Library/Server/Postgres\ For\ Server\ Services/Data

    serveradmin start postgres

  • by Robb Allan,

    Robb Allan Robb Allan Mar 25, 2014 7:54 PM in response to Robb Allan
    Level 2 (354 points)
    Servers Enterprise
    Mar 25, 2014 7:54 PM in response to Robb Allan

    Modify that:

     

    1. sudo -s
    2. serveradmin stop postgres
    3. cp -R /Library/Server/Postgres/Config /Library/Server/Postgres\ For\ Server\ Services/
    4. cp -R /Library/Server/Postgres/Data /Library/Server/Postgres\ For\ Server\ Services/
    5. cd /Library/Server/Postgres\ For\ Server\ Services/Config/
    6. mv org.postgresql.postgres.plist com.apple.postgres.plist
    7. edit com.apple.postgres.plist: change "/Library/Server/PostgreSQL/Data" to "/Library/Server/PostgreSQL For Server Services/Data"
    8. serveradmin start postgres

  • by DOLAdmin,

    DOLAdmin DOLAdmin May 30, 2014 10:53 AM in response to regoli
    Level 1 (0 points)
    May 30, 2014 10:53 AM in response to regoli

    Just seeing this:  If anyone can help with a related request: https://discussions.apple.com/thread/6293078

  • by Colin Sutton,

    Colin Sutton Colin Sutton Jun 14, 2014 5:24 PM in response to Robb Allan
    Level 1 (34 points)
    Mac OS X
    Jun 14, 2014 5:24 PM in response to Robb Allan

    I also upgraded from Lion Server to Mavericks Server and see 'missing postgres config file: /Library/Server/PostgreSQL For Server Services/Config/com.apple.postgres.plist' in the logfile.

    At step 3 the response is:

    cp: directory /Library/Server/Postgres For Server Services does not exist.

  • by ajm_from_WA,

    ajm_from_WA ajm_from_WA Jul 25, 2014 8:41 PM in response to Colin Sutton
    Level 1 (12 points)
    Jul 25, 2014 8:41 PM in response to Colin Sutton

    try

    cp -R /Library/Server/PostgreSQL/Config /Library/Server/PostgreSQL\ For\ Server\ Services/

     

    cp -R /Library/Server/PostgreSQL/Data /Library/Server/PostgreSQL\ For\ Server\ Services/

     

    cd /Library/Server/PostgreSQL\ For\ Server\ Services/Config/

     

    after that, i had to to the rest manually, but got started anyway

  • by rdoust,

    rdoust rdoust Oct 14, 2014 11:16 AM in response to Robb Allan
    Level 1 (80 points)
    Oct 14, 2014 11:16 AM in response to Robb Allan

    I'm late in getting around to this update from Mountain Lion to Mavericks, mostly because I hate having to deal with these changes that Apple makes to how they start and configure services they'd rather end-users not use. Having updated, and requiring Postgres for my own database, I am having a heck of time figuring out how to get Postgres to listen on all addresses. I've followed your instructions (with paths specified correctly), but am unable to restart Postgres. I have no idea why. It just times out waiting for Postgres to start. I can't find a log anywhere that gives any indication as to what the problem might be. This is very perplexing.