[ClusterLabs] PAF / PGSQLMS on Ubuntu

[Andrei Borzenkov]

On Thu, Sep 7, 2023 at 5:01 PM lejeczek via Users <users at clusterlabs.org> wrote:
>
> Hi guys.
>
> I'm trying to set ocf_heartbeat_pgsqlms agent but I get:
> ...
> Failed Resource Actions:
>   * PGSQL-PAF-5433 stop on ubusrv3 returned 'invalid parameter' because 'Parameter "recovery_target_timeline" MUST be set to 'latest'. It is currently set to ''' at Thu Sep  7 13:58:06 2023 after 54ms
>
> I'm new to Ubuntu and I see that Ubuntu has a bit different approach to paths (in comparison to how Centos do it).
> I see separation between config & data, eg.
>
> 14  paf     5433 down   postgres /var/lib/postgresql/14/paf     /var/log/postgresql/postgresql-14-paf.log
>
> I create the resource like here:
>
> -> $ pcs resource create PGSQL-PAF-5433 ocf:heartbeat:pgsqlms pgport=5433 bindir=/usr/bin pgdata=/etc/postgresql/14/paf datadir=/var/lib/postgresql/14/paf meta failure-timeout=30s master-max=1 op start timeout=60s op stop timeout=60s op promote timeout=30s op demote timeout=120s op monitor interval=15s timeout=10s role="Promoted" op monitor interval=16s timeout=10s role="Unpromoted" op notify timeout=60s promotable notify=true failure-timeout=30s master-max=1 --disable
>
> Ubuntu 22.04.3 LTS
> What am I missing can you tell?

Exactly what the message tells you. You need to set recovery_target=latest.