[ClusterLabs] Fwd: Postgres pacemaker cluster failure

[Andrei Borzenkov]

On Wed, Jul 10, 2019 at 12:42 PM Jehan-Guillaume de Rorthais
<jgdr at dalibo.com> wrote:

>
> > > Jul 09 09:16:32 [2679] postgres1       lrmd:    debug:
> > > child_kill_helper:  Kill pid 12735's group Jul 09 09:16:34 [2679]
> > > postgres1       lrmd:  warning: child_timeout_callback:
> > > PGSQL_monitor_15000 process (PID 12735) timed out
> >
> > You probably want to enable debug output in resource agent. As far as I
> > can tell, this requires HA_debug=1 in environment of resource agent, but
> > for the life of me I cannot find where it is possible to set it.
> >
> > Probably setting it directly in resource agent for debugging is the most
> > simple way.
>
> I usually set this in "/etc/sysconfig/pacemaker". Never tried to add it
> to pgsqlms, interesting.

As far as I understand it will set it for every process spawned by
pacemaker which may be too much (it would enable debug output in every
resource agent for every resource). Some generic mean to set it for
specific resource only may be useful for targeted troubleshooting.

Today one could also simply set environment variable in systemd unit
definition but that will have the same global effect.