On 07/09/2023 16:09, Andrei Borzenkov wrote:
On Thu, Sep 7, 2023 at 5:01 PM lejeczek via Users <users@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.
and having it in 'postgresql.conf' make it all work for you?
I've had it and got those errors - perhaps that has to be
set some place else.
_______________________________________________
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users
ClusterLabs home: https://www.clusterlabs.org/
