Re: [ClusterLabs] PAF with postgresql 13?

2022-06-24 Thread Jehan-Guillaume de Rorthais
Hi, On Wed, 22 Jun 2022 16:36:03 + CHAMPAGNE Julie wrote: > ... > # pcs resource create pgsqld ocf:heartbeat:pgsqlms \ > pgdata="/etc/postgresql/11/main" \ > bindir="/usr/lib/postgresql/11/bin" \ > datadir="/var/lib/postgresql/11/main" \ >

Re: [ClusterLabs] PAF with postgresql 13?

2022-06-22 Thread CHAMPAGNE Julie
NE Julie Cc : > Cluster Labs - All topics related to open-source clustering welcomed > Objet : Re: [ClusterLabs] PAF with postgresql 13? > > Hi, > > On Tue, 8 Mar 2022 08:00:22 + > CHAMPAGNE Julie wrote: > > > I've created the ressource pgsqld as follow

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-09 Thread Tomas Jelinek
Dne 08. 03. 22 v 23:08 Ken Gaillot napsal(a): On Tue, 2022-03-08 at 17:20 +0100, Jehan-Guillaume de Rorthais wrote: Hi, Sorry, your mail was really hard to read on my side, but I think I understood and try to answer bellow. On Tue, 8 Mar 2022 11:45:30 + lejeczek via Users wrote: On

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread Ken Gaillot
On Tue, 2022-03-08 at 17:20 +0100, Jehan-Guillaume de Rorthais wrote: > Hi, > > Sorry, your mail was really hard to read on my side, but I think I > understood > and try to answer bellow. > > On Tue, 8 Mar 2022 11:45:30 + > lejeczek via Users wrote: > > > On 08/03/2022 10:21,

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread Jehan-Guillaume de Rorthais
On Tue, 8 Mar 2022 17:44:36 + lejeczek via Users wrote: > On 08/03/2022 16:20, Jehan-Guillaume de Rorthais wrote: > > Removing the node attributes with the resource might be legit from the > > Pacemaker point of view, but I'm not sure how they can track the dependency > > (ping Ken?). > > >

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread lejeczek via Users
On 08/03/2022 16:20, Jehan-Guillaume de Rorthais wrote: Removing the node attributes with the resource might be legit from the Pacemaker point of view, but I'm not sure how they can track the dependency (ping Ken?). PAF has no way to know the ressource is being deleted and can not remove its

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread Jehan-Guillaume de Rorthais
Hi, Sorry, your mail was really hard to read on my side, but I think I understood and try to answer bellow. On Tue, 8 Mar 2022 11:45:30 + lejeczek via Users wrote: > On 08/03/2022 10:21, Jehan-Guillaume de Rorthais wrote: > >> op start timeout=60s \ op stop timeout=60s \ op promote

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread Jehan-Guillaume de Rorthais
read this page as well: https://clusterlabs.github.io/PAF/administration.html Regards, > -Message d'origine- > De : Jehan-Guillaume de Rorthais > Envoyé : mardi 8 mars 2022 11:21 > À : CHAMPAGNE Julie > Cc : Cluster Labs - All topics related to open-source clustering welc

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread CHAMPAGNE Julie
-Message d'origine- De : Jehan-Guillaume de Rorthais Envoyé : mardi 8 mars 2022 11:21 À : CHAMPAGNE Julie Cc : Cluster Labs - All topics related to open-source clustering welcomed Objet : Re: [ClusterLabs] PAF with postgresql 13? Hi, On Tue, 8 Mar 2022 08:00:22 + CHAMPAGNE Julie wrote

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread CHAMPAGNE Julie
r/lib/postgresql/13/bin"; my $pgdata_default = "/var/lib/postgresql/13/main"; Thanks ! -Message d'origine- De : Jehan-Guillaume de Rorthais Envoyé : lundi 7 mars 2022 22:51 À : CHAMPAGNE Julie Cc : Cluster Labs - All topics related to open-source clustering welcomed Obje

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread lejeczek via Users
On 08/03/2022 10:21, Jehan-Guillaume de Rorthais wrote: op start timeout=60s \ op stop timeout=60s \ op promote timeout=30s >> \ op demote timeout=120s \ op monitor interval=15s timeout=10s >> role="Master" meta master-max=1 \ op monitor interval=16s >> timeout=10s role="Slave" \ op notify

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-08 Thread Jehan-Guillaume de Rorthais
Hi, On Tue, 8 Mar 2022 08:00:22 + CHAMPAGNE Julie wrote: > I've created the ressource pgsqld as follow (don't think the cluster creation > command is necessary): > > pcs resource create pgsqld ocf:heartbeat:pgsqlms promotable \ The problem is here. The argument order given to pcs is

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-07 Thread Jehan-Guillaume de Rorthais
On Mon, 7 Mar 2022 14:49:35 + CHAMPAGNE Julie wrote: > The return gives nothing for the first command. > Then: > > name="test-debug" host="node1" value="testvalue" for node1. > > After executing both commands on node2, it gives me the following return on > both server: > >

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-07 Thread CHAMPAGNE Julie
e="testvalue" name="test-debug" host="node1" value="testvalue" -Message d'origine- De : Jehan-Guillaume de Rorthais Envoyé : lundi 7 mars 2022 15:45 À : CHAMPAGNE Julie Cc : Cluster Labs - All topics related to open-source clustering welcomed Obje

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-07 Thread CHAMPAGNE Julie
comed Objet : Re: [ClusterLabs] PAF with postgresql 13? Hi, Caution, this is an english spoken mailing list :) Bellow my answer. On Mon, 7 Mar 2022 12:31:07 + CHAMPAGNE Julie wrote: > Lorsque je crée un problème sur le noeud1, What's the issue you are testing precisely? >

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-07 Thread Jehan-Guillaume de Rorthais
On Mon, 7 Mar 2022 14:32:46 + CHAMPAGNE Julie wrote: > root@node1 ~ > attrd_updater --private --lifetime reboot --name > "lsn_location-pgsqld" --query Could not query value of lsn_location-pgsqld: > attribute does not exist Mh, sorry, could you please exec these two commands:

Re: [ClusterLabs] PAF with postgresql 13?

2022-03-07 Thread Jehan-Guillaume de Rorthais
Hi, Caution, this is an english spoken mailing list :) Bellow my answer. On Mon, 7 Mar 2022 12:31:07 + CHAMPAGNE Julie wrote: > Lorsque je crée un problème sur le noeud1, What's the issue you are testing precisely? > * pgsqld_promote_0 on node2 'error' (1): call=24,

Re: [ClusterLabs] PAF with postgresql 13?

2022-02-22 Thread lejeczek via Users
On 21/02/2022 16:01, Jehan-Guillaume de Rorthais wrote: On Mon, 21 Feb 2022 09:04:27 + CHAMPAGNE Julie wrote: ... The last release is 2 years old, is it still in development? There's no activity because there's not much to do on it. PAF is mainly in maintenance (bug fix) mode. I have few

Re: [ClusterLabs] PAF with postgresql 13?

2022-02-21 Thread Jehan-Guillaume de Rorthais
On Mon, 21 Feb 2022 09:04:27 + CHAMPAGNE Julie wrote: ... > The last release is 2 years old, is it still in development? There's no activity because there's not much to do on it. PAF is mainly in maintenance (bug fix) mode. I have few ideas here and there. It might land soon or later, but

Re: [ClusterLabs] PAF with postgresql 13?

2022-02-21 Thread damiano giuliani
got few fully working cluster with PAF 2.3.0 and postgres13, probably your configuration is not working correclty. BR Damiano Il giorno lun 21 feb 2022 alle ore 15:44 CHAMPAGNE Julie < julie.champa...@pm.gouv.fr> ha scritto: > Hi, > > > > Does PAF 2.3.0

[ClusterLabs] PAF with postgresql 13?

2022-02-21 Thread CHAMPAGNE Julie
Hi, Does PAF 2.3.0 https://github.com/ClusterLabs/PAF/releases/tag/v2.3.0 work with postgresql 13? The cluster works but the slave never gets promoted when the master fails. The last release is 2 years old, is it still in development? Thanks Julie C