PostgreSQL config location os x 10.9 server 3.0

I've got this same problem, amongst others - have you had an luck finding an answer yet... kind of good to know I'm not the only one!

I'm on the same boat!

This is causing a bunch of other errors - a lot of my services on the server are knocked out 😟

getting the same error message

It would seem migration didn't complete properly/fully...

I think I might be getting somewhere, a little, though whether it's really the way to solve it...!

I logged in via terminal and copied and renamed the plist file from the previous verion

sudo cp /Library/Server/PostgreSQL/Config/org.postgresql.postgres.plist ¬

/Library/Server/"PostgreSQL For Server Services"/com.apple.postgres.plist

I don’t now get the error message re missing config, and wiki services seem okay but I do now get:

ServerBackup[85207]: Error in calling backup command for service postgresql, error :=-1

@peak. I have the same error on a fresh install on mavericks! - so, im pretty sure its not because of a incomplete upgradation/migration. You'd think that Apple would do a QA on things like this.

I'll try your idea of copying over the plist file. Fingers crossed.

BTW. I entered 6 bug against Server 3.0 - VPN, Wiki, Postgres SQL and 3 other issues that are unique to my setup. I also Reported a Problem on the iTunes receipt for the $20 I paid on the app store - they have refunded my $20 - that goes a little way in helping quelch my anger. On the Report a Problem form point to 4/5 threads running on discussions.apple.com that are affecting you.

Cheers. Please do keep us posted if you can resolve the backup command issue.

Okay, on a fresh install!

Might be back to the drawing board for me then!

You can find that file if you backed up the previous version of server (2.2.2) with time machine. Restoring it to the original location (as root) makes the error dissapear but as far as I can see it doesn't fix anything.

A fresh install doesn't fix the problem! It would be a waste of time.

Time Machine backups of the Server 3 spontaneously happened even though the following sequence of log messages, and an extended "preparing backup" message (in System Preferences after I manually initiated a backup) led me to believe that backups were broken:

Nov  9 00:24:02 ... servermgr_postgres_server: missing postgres config file: /Library/Server/PostgreSQL For Server Services/Config/com.apple.postgres.plist

Nov  9 00:05:01 ... Error in calling backup command for service postgresql, error :=-1

Nov  9 00:36:43 ... com.apple.backupd[786]: Found 457677 files (13.67 GB) needing backup

Nov  9 00:36:44 ...[786]: 18.47 GB required (including padding), 648.92 GB available

Nov  9 01:06:26 ... com.apple.backupd[786]: Created new backup: 2013-11-09-010625

So, in the event, the backup daemon was able to call the backup command, despite the previous log messages. These are large post-upgrade of Server and other Mavericks Apps that take a while to prepare and to write.

This behaviour observed through the system log is counter-intuitive and probably not the same as previous sorrespondents .... but probably worth noting.

I think that I misinterpreted the system log and that Time Machine backups are completing but postgres backups might well not be included in the backups.

Bump. same error. bought a new mini to add as a client to my server, can't bind the mini (topic of another thread), network accounts do not show (another thread topic) and see this error in log:

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

any help from Apple?

I had got this largley sorted, I think, my cp'ing an old postgres.plist file (see my post above) but on upgrading Server to 3.0.1 it all got hosed again - the plist file was removed, as was the old data directory!

I couldn't be bothered going through all my previous fixes so I moved back to using MySQL (I had Roundcube using Postgre), did re cp the plist file, and I've called it a day on PG for any of my own needs. I can see the writing on the wall that a future Server upgrade would most likely strip out my fixes.

Server would only seem to be using the Postgre instance installed within Server App and that this is used for the Profile Manager.

Hi,

I have the same problem with missing postgres config file. Have anyone found a solution? If only one person had the file and could share it witht the rest of us, the problem wouldd be solved. Does ANYONE have a working com.apple.postgres.plist file to share?

Regards

Jonas

Sweden

Can't remember where I found it but this is the contents of com.apple.postgre.plist file suggested.

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">

<plist version="1.0">

<dict>

<key>Disabled</key>

<true/>

<key>Label</key>

<string>com.apple.postgres</string>

<key>UserName</key>

<string>_postgres</string>

<key>GroupName</key>

<string>_postgres</string>

<key>ProgramArguments</key>

<array>

<string>/Applications/Server.app/Contents/ServerRoot/usr/bin/xpostgre s</string>

<string>-a</string>

<string>/Library/Server/PostgreSQL For Server Services/Config/com.apple.postgres.plist</string>

</array>

<key>OnDemand</key>

<false/>

<key>StandardErrorPath</key>

<string>/Library/Logs/PostgreSQL/PostgreSQL_Server_Services.log</string>

<key>StandardOutPath</key>

<string>/Library/Logs/PostgreSQL/PostgreSQL_Server_Services.log</string>

<key>ExitTimeOut</key>

<integer>60</integer>

</dict>

</plist>

I tried to use it but ran into permission issues with the destination folder.

There is another discussion here: https://discussions.apple.com/thread/5538674

Tahnk you. It seemed to work for me. At least I got rid of all those messages in the log. Now I just have to deal with the rest of them.