On 07/09/2023 16:20, lejeczek via Users wrote:
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.
In case anybody was in this situation - I was missing one
important bit: _bindir_
Ubuntu's pgSQL binaries have different path - what
resource/agent returns as errors is utterly confusing.
_______________________________________________
Manage your subscription:
https://lists.clusterlabs.org/mailman/listinfo/users
ClusterLabs home: https://www.clusterlabs.org/