<div dir="ltr"><div><div>Hi Michael,<br></div>There is no info in the pg_logs, nothing in /var/log/cluster/corosync.log, do you have to specify the logging somewhere, sorry I&#39;m out of ideas<br></div>Thanks<br> </div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 11, 2015 at 12:20 PM, Michael Schwartzkopff <span dir="ltr">&lt;<a href="mailto:ms@sys4.de" target="_blank">ms@sys4.de</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Am Mittwoch, 11. März 2015, 12:14:02 schrieb Wynand Jansen van Vuuren:<br>
<div><div class="h5">&gt; Hi all,<br>
&gt; I need some advice and help please, I&#39;m pretty new to HA and what I have is<br>
&gt; 2 nodes, with 2 network interfaces, ETH0 and ETH1<br>
&gt; cl1_lb1 IP is 172.28.200.166<br>
&gt; cl2_lb1 IP is 172.28.200.168<br>
&gt; Running on ETH0<br>
&gt;<br>
&gt; The heartbeart is setup on 172.16.0.1 and 172.16.0.3 and running on ETH1,<br>
&gt; my pubic VIP for the 2 nodes is 172.28.200.159 and my VIP for replication<br>
&gt; is 172.26.0.5<br>
&gt;<br>
&gt; When I test pgsql with ocf-tester (I have modified the pgsql file with the<br>
&gt; paths etc), I get the following<br>
&gt;<br>
&gt; cl1_lb1:~ # cd /usr/lib/ocf/resource.d/heartbeat/<br>
&gt; cl1_lb1:/usr/lib/ocf/resource.d/heartbeat # ocf-tester -v -n resourcename<br>
&gt; pgsql<br>
&gt; Beginning tests for pgsql...<br>
&gt; Testing permissions with uid nobody<br>
&gt; Testing: meta-data<br>
&gt; Testing: meta-data<br>
&gt; &lt;?xml version=&quot;1.0&quot;?&gt;<br>
&gt; &lt;!DOCTYPE resource-agent SYSTEM &quot;ra-api-1.dtd&quot;&gt;<br>
&gt; &lt;resource-agent name=&quot;pgsql&quot;&gt;<br>
&gt; &lt;version&gt;1.0&lt;/version&gt;<br>
&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Resource script for PostgreSQL. It manages a PostgreSQL as an HA resource.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;Manages a PostgreSQL database instance&lt;/shortdesc&gt;<br>
&gt;<br>
&gt; &lt;parameters&gt;<br>
&gt; &lt;parameter name=&quot;pgctl&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Path to pg_ctl command.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pgctl&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/opt/app/PostgreSQL/9.3/bin/pg_ctl&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;start_opt&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Start options (-o start_opt in pg_ctl). &quot;-i -p 5432&quot; for example.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;start_opt&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt; &lt;parameter name=&quot;ctl_opt&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Additional pg_ctl options (-w, -W etc..).<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;ctl_opt&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;psql&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Path to psql command.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;psql&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/opt/app/PostgreSQL/9.3/bin/psql&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;pgdata&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Path to PostgreSQL data directory.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pgdata&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/opt/app/pgdata/9.3&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;pgdba&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; User that owns PostgreSQL.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pgdba&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;postgres&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;pghost&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Hostname/IP address where PostgreSQL is listening<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pghost&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;pgport&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Port where PostgreSQL is listening<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pgport&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;integer&quot; default=&quot;5432&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;pglibs&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Custom location of the Postgres libraries. If not set, the standard location<br>
&gt; will be used.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pglibs&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/opt/app/PostgreSQL/9.3/lib&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;monitor_user&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; PostgreSQL user that pgsql RA will user for monitor operations. If it&#39;s not<br>
&gt; set<br>
&gt; pgdba user will be used.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;monitor_user&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;monitor_password&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Password for monitor user.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;monitor_password&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;monitor_sql&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; SQL script that will be used for monitor operations.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;monitor_sql&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;select now();&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;config&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Path to the PostgreSQL configuration file for the instance.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;Configuration file&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/opt/app/pgdata/9.3/postgresql.conf&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;pgdb&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Database that will be used for monitoring.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;pgdb&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;template1&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;logfile&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Path to PostgreSQL server log output file.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;logfile&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/dev/null&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;socketdir&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Unix socket directory for PostgreSQL.<br>
&gt;<br>
&gt; If you use PostgreSQL 9.3 or higher and define unix_socket_directories in<br>
&gt; the postgresql.conf, then you must set socketdir to determine which<br>
&gt; directory is used for psql command.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;socketdir&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;stop_escalate&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Number of shutdown retries (using -m fast) before resorting to -m immediate<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;stop escalation&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;integer&quot; default=&quot;30&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;rep_mode&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Replication mode may be set to &quot;async&quot; or &quot;sync&quot; or &quot;slave&quot;.<br>
&gt; They require PostgreSQL 9.1 or later.<br>
&gt; Once set, &quot;async&quot; and &quot;sync&quot; require node_list, master_ip, and<br>
&gt; restore_command parameters,as well as configuring PostgreSQL<br>
&gt; for replication (in postgresql.conf and pg_hba.conf).<br>
&gt;<br>
&gt; &quot;slave&quot; means that RA only makes recovery.conf before starting<br>
&gt; to connect to primary which is running somewhere.<br>
&gt; It dosen&#39;t need master/slave setting.<br>
&gt; It requires master_ip restore_command parameters.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;rep_mode&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;none&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;node_list&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; All node names. Please separate each node name with a space.<br>
&gt; This is required for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;node list&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;restore_command&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; restore_command for recovery.conf.<br>
&gt; This is required for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;restore_command&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;archive_cleanup_command&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; archive_cleanup_command for recovery.conf.<br>
&gt; This is used for replication and is optional.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;archive_cleanup_command&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;recovery_end_command&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; recovery_end_command for recovery.conf.<br>
&gt; This is used for replication and is optional.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;recovery_end_command&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;master_ip&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Master&#39;s floating IP address to be connected from hot standby.<br>
&gt; This parameter is used for &quot;primary_conninfo&quot; in recovery.conf.<br>
&gt; This is required for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;master ip&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;repuser&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; User used to connect to the master server.<br>
&gt; This parameter is used for &quot;primary_conninfo&quot; in recovery.conf.<br>
&gt; This is required for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;repuser&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;postgres&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;primary_conninfo_opt&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; primary_conninfo options of recovery.conf except host, port, user and<br>
&gt; application_name.<br>
&gt; This is optional for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;primary_conninfo_opt&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;restart_on_promote&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; If this is true, RA deletes recovery.conf and restarts PostgreSQL<br>
&gt; on promote to keep Timeline ID. It probably makes fail-over slower.<br>
&gt; It&#39;s recommended to set on-fail of promote up as fence.<br>
&gt; This is optional for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;restart_on_promote&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;boolean&quot; default=&quot;false&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;tmpdir&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Path to temporary directory.<br>
&gt; This is optional for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;tmpdir&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;string&quot; default=&quot;/var/lib/pgsql/tmp&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;xlog_check_count&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Number of checks of xlog on monitor before promote.<br>
&gt; This is optional for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;xlog check count&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;integer&quot; default=&quot;&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;crm_attr_timeout&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; The timeout of crm_attribute forever update command.<br>
&gt; Default value is 5 seconds.<br>
&gt; This is optional for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;The timeout of crm_attribute forever update<br>
&gt; command.&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;integer&quot; default=&quot;5&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;stop_escalate_in_slave&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; Number of shutdown retries (using -m fast) before resorting to -m immediate<br>
&gt; in slave state.<br>
&gt; This is optional for replication.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;stop escalation_in_slave&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;integer&quot; default=&quot;30&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt;<br>
&gt; &lt;parameter name=&quot;check_wal_receiver&quot; unique=&quot;0&quot; required=&quot;0&quot;&gt;<br>
&gt; &lt;longdesc lang=&quot;en&quot;&gt;<br>
&gt; If this is true, RA checks wal_receiver process on monitor<br>
&gt; and notifies its status using &quot;(resource name)-receiver-status&quot; attribute.<br>
&gt; It&#39;s useful for checking whether PostgreSQL (hot standby) connects to<br>
&gt; primary.<br>
&gt; The attribute shows status as &quot;normal&quot; or &quot;ERROR&quot;.<br>
&gt; &lt;/longdesc&gt;<br>
&gt; &lt;shortdesc lang=&quot;en&quot;&gt;check_wal_receiver&lt;/shortdesc&gt;<br>
&gt; &lt;content type=&quot;boolean&quot; default=&quot;false&quot; /&gt;<br>
&gt; &lt;/parameter&gt;<br>
&gt; &lt;/parameters&gt;<br>
&gt;<br>
&gt; &lt;actions&gt;<br>
&gt; &lt;action name=&quot;start&quot; timeout=&quot;120&quot; /&gt;<br>
&gt; &lt;action name=&quot;stop&quot; timeout=&quot;120&quot; /&gt;<br>
&gt; &lt;action name=&quot;status&quot; timeout=&quot;60&quot; /&gt;<br>
&gt; &lt;action name=&quot;monitor&quot; depth=&quot;0&quot; timeout=&quot;30&quot; interval=&quot;30&quot;/&gt;<br>
&gt; &lt;action name=&quot;monitor&quot; depth=&quot;0&quot; timeout=&quot;30&quot; interval=&quot;29&quot; role=&quot;Master&quot; /&gt;<br>
&gt; &lt;action name=&quot;promote&quot; timeout=&quot;120&quot; /&gt;<br>
&gt; &lt;action name=&quot;demote&quot; timeout=&quot;120&quot; /&gt;<br>
&gt; &lt;action name=&quot;notify&quot;   timeout=&quot;90&quot; /&gt;<br>
&gt; &lt;action name=&quot;meta-data&quot; timeout=&quot;5&quot; /&gt;<br>
&gt; &lt;action name=&quot;validate-all&quot; timeout=&quot;5&quot; /&gt;<br>
&gt; &lt;action name=&quot;methods&quot; timeout=&quot;5&quot; /&gt;<br>
&gt; &lt;/actions&gt;<br>
&gt; &lt;/resource-agent&gt;<br>
&gt; Testing: validate-all<br>
&gt; Checking current state<br>
&gt; Testing: stop<br>
&gt; INFO: waiting for server to shut down..... done server stopped<br>
&gt; INFO: PostgreSQL is down<br>
&gt; Testing: monitor<br>
&gt; INFO: PostgreSQL is down<br>
&gt; Testing: monitor<br>
&gt; ocf-exit-reason:Setup problem: couldn&#39;t find command:<br>
&gt; /opt/app/PostgreSQL/9.3/bin/pg_ctl<br>
&gt; Testing: start<br>
&gt; INFO: server starting<br>
&gt; INFO: PostgreSQL start command sent.<br>
&gt; INFO: PostgreSQL is down<br>
&gt; DEBUG: PostgreSQL still hasn&#39;t started yet. Waiting...<br>
&gt; INFO: PostgreSQL is started.<br>
&gt; Testing: monitor<br>
&gt; Testing: monitor<br>
&gt; INFO: Don&#39;t check /opt/app/pgdata/9.3 during probe<br>
&gt; Testing: notify<br>
&gt; Checking for demote action<br>
&gt; ocf-exit-reason:Not in a replication mode.<br>
&gt; Checking for promote action<br>
&gt; ocf-exit-reason:Not in a replication mode.<br>
&gt; Testing: demotion of started resource<br>
&gt; ocf-exit-reason:Not in a replication mode.<br>
&gt; * rc=6: Demoting a start resource should not fail<br>
&gt; Testing: promote<br>
&gt; ocf-exit-reason:Not in a replication mode.<br>
&gt; * rc=6: Promote failed<br>
&gt; Testing: demote<br>
&gt; ocf-exit-reason:Not in a replication mode.<br>
&gt; * rc=6: Demote failed<br>
&gt; Aborting tests<br>
&gt; cl1_lb1:/usr/lib/ocf/resource.d/heartbeat # su - postgres<br>
&gt; postgres@cl1_lb1:~&gt; pg_ctl -D /opt/app/pgdata/9.3 status<br>
&gt; pg_ctl: server is running (PID: 21575)<br>
&gt; /opt/app/PostgreSQL/9.3/bin/postgres &quot;-D&quot; &quot;/opt/app/pgdata/9.3&quot; &quot;-c&quot;<br>
&gt; &quot;config_file=/opt/app/pgdata/9.3/postgresql.conf&quot;<br>
&gt;<br>
&gt; Postgres seem to be running ok on both nodes and the streaming is taking<br>
&gt; place<br>
&gt;<br>
&gt; postgres@cl1_lb1:~&gt; exit<br>
&gt; logout<br>
&gt; cl1_lb1:/usr/lib/ocf/resource.d/heartbeat # crm_mon -1 -Af<br>
&gt; Last updated: Wed Mar 11 12:05:17 2015<br>
&gt; Last change: Wed Mar 11 12:03:10 2015 by root via crm_attribute on cl1_lb1<br>
&gt; Stack: classic openais (with plugin)<br>
&gt; Current DC: cl1_lb1 - partition with quorum<br>
&gt; Version: 1.1.9-2db99f1<br>
&gt; 2 Nodes configured, 2 expected votes<br>
&gt; 4 Resources configured.<br>
&gt;<br>
&gt;<br>
&gt; Online: [ cl1_lb1 cl2_lb1 ]<br>
&gt;<br>
&gt;  Master/Slave Set: msPostgresql [pgsql]<br>
&gt;      pgsql:0    (ocf::heartbeat:pgsql):    Slave cl1_lb1 FAILED<br>
&gt;      Stopped: [ pgsql:1 ]<br>
&gt;<br>
&gt; Node Attributes:<br>
&gt; * Node cl1_lb1:<br>
&gt;     + master-pgsql                        : -INFINITY<br>
&gt;     + pgsql-data-status                   : LATEST<br>
&gt;     + pgsql-status                        : STOP<br>
&gt; * Node cl2_lb1:<br>
&gt;     + master-pgsql                        : 100<br>
&gt;     + pgsql-data-status                   : STREAMING|SYNC<br>
&gt;     + pgsql-status                        : STOP<br>
&gt;<br>
&gt; Migration summary:<br>
&gt; * Node cl1_lb1:<br>
&gt;    pgsql:0: migration-threshold=1 fail-count=1 last-failure=&#39;Wed Mar 11<br>
&gt; 12:04:42 2015&#39;<br>
&gt; * Node cl2_lb1:<br>
&gt;    pgsql:0: migration-threshold=1 fail-count=1000000 last-failure=&#39;Wed Mar<br>
&gt; 11 12:01:40 2015&#39;<br>
&gt;<br>
&gt; Failed actions:<br>
&gt;     pgsql_monitor_3000 (node=cl1_lb1, call=132, rc=1, status=complete):<br>
&gt; unknown error<br>
&gt;     pgsql_start_0 (node=cl2_lb1, call=90, rc=1, status=complete): unknown<br>
&gt; error<br>
&gt; cl1_lb1:/usr/lib/ocf/resource.d/heartbeat # crm configure show<br>
&gt; node cl1_lb1 \<br>
&gt;     attributes pgsql-data-status=&quot;LATEST&quot;<br>
&gt; node cl2_lb1 \<br>
&gt;     attributes pgsql-data-status=&quot;STREAMING|SYNC&quot;<br>
&gt; primitive pgsql ocf:heartbeat:pgsql \<br>
&gt;     params pgctl=&quot;/opt/app/PostgreSQL/9.3/bin/pg_ctl&quot;<br>
&gt; psql=&quot;/opt/app/PostgreSQL/9.3/bin/psql&quot;<br>
&gt; config=&quot;/opt/app/pgdata/9.3/postgresql.conf&quot; pgdba=&quot;postgres&quot;<br>
&gt; pgdata=&quot;/opt/app/pgdata/9.3/&quot; start_opt=&quot;-p 5432&quot; rep_mode=&quot;sync&quot;<br>
&gt; node_list=&quot;cl1_lb1 cl2_lb1&quot; restore_command=&quot;cp /pgtablespace/archive/%f<br>
&gt; %p&quot; primary_conninfo_opt=&quot;keepalives_idle=60 keepalives_interval=5<br>
&gt; keepalives_count=5&quot; master_ip=&quot;172.16.0.5&quot; restart_on_promote=&quot;true&quot;<br>
&gt; logfile=&quot;/var/log/OCF.log&quot; \<br>
&gt;     op start interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt;     op monitor interval=&quot;4s&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt;     op monitor interval=&quot;3s&quot; role=&quot;Master&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt; op promote interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt;     op demote interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;stop&quot; \<br>
&gt;     op stop interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;block&quot; \<br>
&gt;     op notify interval=&quot;0s&quot; timeout=&quot;60s&quot;<br>
&gt; primitive vip-master ocf:heartbeat:IPaddr2 \<br>
&gt;     params ip=&quot;172.28.200.159&quot; nic=&quot;eth0&quot; cidr_netmask=&quot;24&quot; \<br>
&gt;     op start interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;stop&quot; \<br>
&gt;     op monitor interval=&quot;10s&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt;     op stop interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;block&quot;<br>
&gt; primitive vip-rep ocf:heartbeat:IPaddr2 \<br>
&gt;     params ip=&quot;172.16.0.5&quot; nic=&quot;eth1&quot; cidr_netmask=&quot;24&quot; \<br>
&gt;     meta migration-threshold=&quot;0&quot; \<br>
&gt;     op start interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt;     op monitor interval=&quot;10s&quot; timeout=&quot;60s&quot; on-fail=&quot;restart&quot; \<br>
&gt;     op stop interval=&quot;0s&quot; timeout=&quot;60s&quot; on-fail=&quot;block&quot;<br>
&gt; group master-group vip-master vip-rep<br>
&gt; ms msPostgresql pgsql \<br>
&gt;     meta master-max=&quot;1&quot; master-node-max=&quot;1&quot; clone-max=&quot;2&quot;<br>
&gt; clone-node-max=&quot;1&quot; notify=&quot;true&quot;<br>
&gt; colocation rsc_colocation-1 inf: master-group msPostgresql:Master<br>
&gt; order rsc_order-1 0: msPostgresql:promote master-group:start<br>
&gt; symmetrical=false<br>
&gt; order rsc_order-2 0: msPostgresql:demote master-group:stop symmetrical=false<br>
&gt; property $id=&quot;cib-bootstrap-options&quot; \<br>
&gt;     dc-version=&quot;1.1.9-2db99f1&quot; \<br>
&gt;     cluster-infrastructure=&quot;classic openais (with plugin)&quot; \<br>
&gt;     expected-quorum-votes=&quot;2&quot; \<br>
&gt;     no-quorum-policy=&quot;ignore&quot; \<br>
&gt;     stonith-enabled=&quot;false&quot; \<br>
&gt;     crmd-transition-delay=&quot;0s&quot; \<br>
&gt;     last-lrm-refresh=&quot;1426067955&quot;<br>
&gt; rsc_defaults $id=&quot;rsc-options&quot; \<br>
&gt;     resource-stickiness=&quot;INFINITY&quot; \<br>
&gt;     migration-threshold=&quot;1&quot;<br>
&gt; cl1_lb1:/usr/lib/ocf/resource.d/heartbeat #<br>
&gt;<br>
&gt; It seems that pgsql is not playing nicely with my Postgres install, any<br>
&gt; hints tips what to look for please??<br>
&gt; Thanks<br>
<br>
<br>
</div></div>Look into the logs. The pgsql agent writes errors to the logs.<br>
<br>
Search in your logs on cl2_lb1 around  12:01:40 2015.<br>
<br>
<br>
Mit freundlichen Grüßen,<br>
<br>
Michael Schwartzkopff<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
[*] sys4 AG<br>
<br>
<a href="http://sys4.de" target="_blank">http://sys4.de</a>, <a href="tel:%2B49%20%2889%29%2030%2090%2046%2064" value="+498930904664">+49 (89) 30 90 46 64</a>, <a href="tel:%2B49%20%28162%29%20165%200044" value="+491621650044">+49 (162) 165 0044</a><br>
Franziskanerstraße 15, 81669 München<br>
<br>
Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263<br>
Vorstand: Patrick Ben Koetter, Marc Schiffbauer<br>
Aufsichtsratsvorsitzender: Florian Kirstein</font></span><br>_______________________________________________<br>
Users mailing list: <a href="mailto:Users@clusterlabs.org">Users@clusterlabs.org</a><br>
<a href="http://clusterlabs.org/mailman/listinfo/users" target="_blank">http://clusterlabs.org/mailman/listinfo/users</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://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
<br></blockquote></div><br></div>