Thank you all for tips and suggestions. I managed to configure postgres so it actually starts.<br><br>First, I updated resource-agents (Florian thanks for the tip, still don't know how did I manage to miss that :) )<br>
Second, I deleted postgres primitive, cleared all failcounts and configure it again like this: <br><br>primitive postgres_res ocf:heartbeat:pgsql \<br> params pgctl="/usr/lib/postgresql/8.4/bin/pg_ctl" psql="/usr/bin/psql" start_opt="" pgdata="/var/lib/postgresql/8.4/main" config="/etc/postgresql/8.4/main/postgresql.conf" pgdba="postgres" \<br>
op start interval="0" timeout="120s" \<br> op stop interval="0" timeout="120s" \<br> op monitor interval="30s" timeout="30s" depth="0"<br>
<br>After that, it all worked like a charm.<br><br>However, I noticed some strange output in the log file, it wasn't there before I updated the resource-agents.<br><br>Here is the extract from the syslog:<br><br><a href="http://pastebin.com/ybPi0VMp">http://pastebin.com/ybPi0VMp</a><br>
<br>(postgres_res:monitor:stderr<span class="br0">)</span> <span class="br0">[</span>: <span class="nu0">647</span>: monitor: unexpected operator<br><br>This error is actually reported with any operator. I tried to start the script from CLI, I got the same thing with ./pgsql start, ./pgsql status, ./pgsql stop<br>
<br>Here is the pgsql script I am using: <br><br><a href="http://pastebin.com/55mKNDCM">http://pastebin.com/55mKNDCM</a><br><br>P..S. you can ignore nginx errors in syslog, I will open a new topic about that<br>