Re: [ClusterLabs] PAF / PGSQLMS on Ubuntu
On Fri, 8 Sep 2023 10:26:42 +0200 lejeczek via Users wrote: > 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 > >> 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. Uh ? Good point, I'll definitely have to check that. Thanks for the report! ___ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/
Re: [ClusterLabs] PAF / PGSQLMS on Ubuntu
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 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/
Re: [ClusterLabs] PAF / PGSQLMS on Ubuntu
On 07/09/2023 16:09, Andrei Borzenkov wrote: On Thu, Sep 7, 2023 at 5:01 PM lejeczek via Users 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/
Re: [ClusterLabs] PAF / PGSQLMS on Ubuntu
On Thu, Sep 7, 2023 at 5:01 PM lejeczek via Users 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. ___ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/