Skip navigation

Postgres not responding

2041 Views 4 Replies Latest reply: Feb 6, 2013 2:02 PM by Andreas Franz. RSS
Eirikur Calculating status...
Currently Being Moderated
Feb 12, 2012 4:52 PM

After a RAM failure my lion server machine went into a recurring kernel panic which forced me to restore the machine from the time machine backup after I'd changed the RAM.

 

But after the restore, webmail and my wiki is not working.

When trying to view the settings of the wiki in Server.app I get the message "Error Reading Settings"

And if I try to open webmail in a browser I get this message:

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

 

When I do "$ sudo serveradmin fullstatus postgres" I get this:

postgres:dataDirHasBeenInitialized = yes

postgres:PG_VERSION = "9.0.5"

postgres:dataDir = "/var/pgsql"

postgres:postgresIsResponding = no

postgres:dataDirIsDirectory = yes

postgres:PGserverVersion = 0

postgres:dataDirExists = yes

postgres:setStateVersion = 1

postgres:state = "RUNNING"

 

I've tried doing sudo serveradmin stop postgres, which gives me this:

postgres:state = "STOPPED"

But then when I do sudo serveradmin start postgres I get this:

postgres:error = "CANNOT_START_SERVICE_TIMEOUT_ERR"

 

I've tried running the scripts in /system/library/ServerSetup/CommonExtras/PosgresSQLExtras/ under sudo, but then I get this:

psql: could not connect to server: No such file or directory

          Is the server running locally and accepting

          connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

 

I gave my self read/write perms to the pgsql folders in /var/ but to no avail.

 

If I do "ls -l /Library/Logs/PostgreSQL.log" under bash, I get this:

-rw-r--r--  1 _postgres  _postgres  0 Feb 12 16:57 /Library/Logs/PostgreSQL.log

So I guess it's able to write to the log.

 

So I'm feeling a bit lost, annyone that could help me see what I'm missing?

Mac mini

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.