[Pacemaker] Postgres RA won't start

[Florian Haas]

On 2011-10-11 16:10, Amar Prasovic wrote:
> Hello everyone,
> 
> I tried to configure postgres RA and I ran into some problems.
> 
> [...]
>
> in crm_mon
> Online: [ webnode02 webnode01 ]
> 
>  Master/Slave Set: drbd_cluster
>      Masters: [ webnode01 ]
>      Slaves: [ webnode02 ]
>  Resource Group: cluster_1
>      fs_res     (ocf::heartbeat:Filesystem):    Started webnode01
>      ClusterIP  (ocf::heartbeat:IPaddr2):       Started webnode01
>      nginx_res  (ocf::heartbeat:nginx):    Started webnode01
>      postgres_res       (ocf::heartbeat:pgsql): Stopped
> 
> Failed actions:
>     postgres_res_start_0 (node=webnode01, call=84, rc=5,
> status=complete): not installed
>     postgres_res_start_0 (node=webnode02, call=66, rc=5,
> status=complete): not installed

There are just 4 scenarios in which pgsql returns OCF_ERR_INSTALLED:

- The resource agent is not installed or is not executable (unlikely);
- pgctl or psql are not installed or not executable;
- the configuration file does not exist or is not readable during a
non-probe;
- the username identified by the "pgdba" resource parameter does not
resolve to a uid.

All of those do log error messages to the log though. You can grep for
ERROR in your logs, it should turn up what went wrong.

Cheers,
Florian

-- 
Need help with Pacemaker?
http://www.hastexo.com/now