<br><div class="gmail_quote">On Wed, Oct 12, 2011 at 9:20 AM, Amar Prasovic <span dir="ltr"><<a href="mailto:amar@linux.org.ba">amar@linux.org.ba</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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><div class="im"><br>primitive postgres_res ocf:heartbeat:pgsql \<br></div> 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" \<div class="im">
<br>
op start interval="0" timeout="120s" \<br> op stop interval="0" timeout="120s" \<br></div> 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" target="_blank">http://pastebin.com/ybPi0VMp</a><br>
<br>(postgres_res:monitor:stderr<span>)</span> <span>[</span>: <span>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>
</blockquote><div><br>Weird. I don't know what to tell. The RA is basically all right, it just misses one nor very important fix. On my system CentOS 5. PosgreSQL 8.4 or 9.0 it doesn't produce any errors. If understand you log right the problem is in line 647 of the RA which is:<br>
<br>[ "$1" == "validate-all" ] && exit $rc<br><br>I do not see why it would complain on this line.<br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>Here is the pgsql script I am using: <br><br><a href="http://pastebin.com/55mKNDCM" target="_blank">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>
<br>_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Serge Dubrouski.<br>