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