Postgresql startup fails

[natediggs]

Hi Everyone,

So I have a 3 piece linux cluster right now that has a postgresql backend that runs off of a iSCSI storage unit that is connected to with OpenISCSI. Today, for some reason the mount of the file system turned to Read-only and then disconnected completely. I think I figured out what the problem is but now, when I try to start PostgreSQL on either server I get a message that the startup failed and then when I try to mount the storage space again the file system has become read only.

Anybody have any idea what is going on here? This is a production system and I have never seen anything like this.

Nate

[TrevorH]

A mount won't go readonly without either being manually mounted ro or getting some sort of I/O error that forces it to go readonly. I suspect that you have yet to fix the underlying problem with the file system and your postgres server is failing the first time it tries to write to the problem filesystem.