Postgres won't start after restart
After restarting my 10.9.4 Server.app version 3.1.2 Wiki and Profile Manger both don't work. Here's a sample from the server log:
Sep 8 11:41:22 server.thewcateam.net collabd[368] <Error>: [CSServiceDispatcher.m:260 8389000 +0ms] Caught exception "Connection to DB failed" [CSDatabaseError] executing [http]Request{AuthService.enterMagicalAuthRealm()}:
(
0 CoreFoundation 0x00007fff8e68925c __exceptionPreprocess + 172
1 libobjc.A.dylib 0x00007fff97cd1e75 objc_exception_throw + 43
2 CSService 0x00000001053769bd -[CSConnectionPool openConnection] + 3309
3 CSService 0x000000010537738a -[CSConnectionPool currentConnection] + 98
4 CSService 0x0000000105406329 -[CSAuthService unauthenticatedSession] + 82
5 CSService 0x0000000105406903 -[CSAuthService currentOrNewSession] + 154
6 CSService 0x0000000105409781 -[CSAuthService enterMagicalAuthRealm] + 51
7 CoreFoundation 0x00007fff8e5749ac __invoking___ + 140
8 CoreFoundation 0x00007fff8e574814 -[NSInvocation invoke] + 308
9 CSService 0x0000000105371a40 -[CSServiceDispatcher executeRequest:asPartOfBatch:usingServiceImpl:] + 4589
10 CSService 0x0000000105371ef7 -[CSServiceDispatcher executeRequest:] + 120
11 CSService 0x00000001053f57d0 +[CSServiceDispatchHTTPRouter routeServiceRequest:response:] + 1135
12 CSService 0x0000000105378d1f __21-[CSServiceBase init]_block_invoke_6 + 48
13 CSService 0x00000001053f281a __53-[CSRoutingHTTPConnection httpResponseForMethod:URI:]_block_invoke + 95
14 CSService 0x00000001053f5d6c -[CSHTTPBackgroundResponse bounce:] + 286
15 Foundation 0x00007fff9298576b __NSThread__main__ + 1318
16 libsystem_pthread.dylib 0x00007fff8efb8899 _pthread_body + 138
17 libsystem_pthread.dylib 0x00007fff8efb872a _pthread_struct_init + 0
18 libsystem_pthread.dylib 0x00007fff8efbcfc9 thread_start + 13
)
Sep 8 11:41:24 server.thewcateam.net collabd[368] <Error>: [CSConnectionPool.m:196 807d000 +2415ms] Could not open a connection to Postgres. Please make sure it is running and has the correct access.
Sep 8 11:41:24 server.thewcateam.net collabd[368] <Error>: [CSXCWorkSchedulerService.m:196 807d000 +0ms] Failed to open DB connection, retrying in 10s: [CSDatabaseError] Connection to DB failed
Sep 8 11:41:33 server.thewcateam.net collabd[368] <Error>: [CSConnectionPool.m:196 8183000 +8272ms] Could not open a connection to Postgres. Please make sure it is running and has the correct access.
Ran the following command:
serveradmin fullstatus postgres_server
returned:
postgres_server:dataDirHasBeenInitialized = yes
postgres_server:PG_VERSION = "9.2.8"
postgres_server:dataDir = "/Library/Server/PostgreSQL For Server Services/Data"
postgres_server:postgresIsResponding = no
postgres_server:dataDirIsDirectory = yes
postgres_server:PGserverVersion = 0
postgres_server:dataDirExists = yes
postgres_server:setStateVersion = 1
postgres_server:state = "STOPPED"
Tried to start postgres:
serveradmin start postgres_server
got the error:
postgres_server:error = "CANNOT_START_SERVICE_ERR"
I get a similar error from Profile Manager if I try to access it. Both CalDAV and CardDAV work fine, so their databases are seemingly unaffected. The postgres instance does appear to be running in Activity Monitor:
I don't have a lot of experience with Postgres can't figure out why Postgres won't start and I'm not sure where to look beyond where I have to find out why.
