Re: [ClusterLabs] corosync won't start after node failure

2024-08-19 Thread Jehan-Guillaume de Rorthais via Users
On Mon, 19 Aug 2024 13:39:29 +0300 Murat Inal wrote: > Hi Jehan, > > When you install corosync & pacemaker packages in Ubuntu, they are > DISABLED by default. pcsd is ENABLED by default. > > So when you do a sudo pcs cluster start, corosync & pacemaker starts. > > BTW, I already tried to solv

Re: [ClusterLabs] corosync won't start after node failure

2024-08-19 Thread Jehan-Guillaume de Rorthais via Users
On Mon, 19 Aug 2024 12:58:09 +0300 Murat Inal wrote: > [Resending the below due to message format problem] > > > Dear List, > > I have been running two different 3-node clusters for some time. I am > having a fatal problem with corosync: After a node failure, rebooted > node does NOT start c

Re: [ClusterLabs] Resource Agents: pgsql vs. pgsqlms

2024-07-12 Thread Jehan-Guillaume de Rorthais via Users
On Thu, 11 Jul 2024 22:20:03 +0200 Ede Wolf wrote: > […] > >> the other the language. Bash is realistic to read, perl probably not. > > > > That's really a matter of taste, and you might be surprised: > > Well, if we manage to get it up and running by help of documentation, > and some trial an

Re: [ClusterLabs] Resource Agents: pgsql vs. pgsqlms

2024-07-11 Thread Jehan-Guillaume de Rorthais via Users
On Thu, 11 Jul 2024 14:12:27 +0200 Ede Wolf wrote: > Just let me take this mail as a placeholder to thank you all very much > for your rather fast replies! You are very welcome. > Just wondering, besides implementation and documentation, is there an > overview of features / percieved advantag

Re: [ClusterLabs] Resource Agents: pgsql vs. pgsqlms

2024-07-11 Thread Jehan-Guillaume de Rorthais via Users
On Thu, 11 Jul 2024 11:52:45 +0200 Oyvind Albrigtsen wrote: > On 11/07/24 11:33 GMT, Jehan-Guillaume de Rorthais wrote: > >On Thu, 11 Jul 2024 10:17:24 +0200 > >Oyvind Albrigtsen wrote: > >[…] > >> >Since postgres ha is rather new to us and me having been lucky not > >> >having had to deal wit

Re: [ClusterLabs] Resource Agents: pgsql vs. pgsqlms

2024-07-11 Thread Jehan-Guillaume de Rorthais via Users
On Thu, 11 Jul 2024 10:17:24 +0200 Oyvind Albrigtsen wrote: […] > >Since postgres ha is rather new to us and me having been lucky not > >having had to deal with perl so far, just reading the agents > >themselves does not really shed that much light on this issue. > The pgsql has seen more testin

Re: [ClusterLabs] Resource Agents: pgsql vs. pgsqlms

2024-07-11 Thread Jehan-Guillaume de Rorthais via Users
Hello Ede, On Wed, 10 Jul 2024 19:18:26 +0200 Ede Wolf wrote: > […] > we are about to set up a postgresql 15 ha solution and since we already > have some experience with pacemaker, this seems the obvious route to go > first. Indeed! > What however is somewhat confusing are the available resou

Re: [ClusterLabs] PostgreSQL server timelines offset after promote

2024-03-27 Thread Jehan-Guillaume de Rorthais via Users
Bonjour Thierry, On Mon, 25 Mar 2024 10:55:06 + FLORAC Thierry wrote: > I'm trying to create a PostgreSQL master/slave cluster using streaming > replication and pgsqlms agent. Cluster is OK but my problem is this : the > master node is sometimes restarted for system operations, and the slave

Re: [ClusterLabs] trigger something at ?

2024-02-01 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 31 Jan 2024 18:23:40 +0100 lejeczek via Users wrote: > On 31/01/2024 17:13, Jehan-Guillaume de Rorthais wrote: > > On Wed, 31 Jan 2024 16:37:21 +0100 > > lejeczek via Users wrote: > > > >> > >> On 31/01/2024 16:06, Jehan-Guillaume de Rorthais wrote: > >>> On Wed, 31 Jan 2024 16:02:12

Re: [ClusterLabs] trigger something at ?

2024-01-31 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 31 Jan 2024 16:37:21 +0100 lejeczek via Users wrote: > > > On 31/01/2024 16:06, Jehan-Guillaume de Rorthais wrote: > > On Wed, 31 Jan 2024 16:02:12 +0100 > > lejeczek via Users wrote: > > > >> > >> On 29/01/2024 17:22, Ken Gaillot wrote: > >>> On Fri, 2024-01-26 at 13:55 +0100, lejecze

Re: [ClusterLabs] trigger something at ?

2024-01-31 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 31 Jan 2024 16:02:12 +0100 lejeczek via Users wrote: > > > On 29/01/2024 17:22, Ken Gaillot wrote: > > On Fri, 2024-01-26 at 13:55 +0100, lejeczek via Users wrote: > >> Hi guys. > >> > >> Is it possible to trigger some... action - I'm thinking specifically > >> at shutdown/start. > >> I

Re: [ClusterLabs] Beginner lost with promotable "group" design

2024-01-31 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 31 Jan 2024 15:41:28 +0100 Adam Cecile wrote: [...] > Thanks a lot for your suggestion, it seems I have something that work > correctly now, final configuration is: I would recommend configuring in an offline CIB then pushing it to production as a whole. Eg.: # get current CIB pcs

Re: [ClusterLabs] Planning for Pacemaker 3

2024-01-25 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 24 Jan 2024 16:47:54 -0600 Ken Gaillot wrote: ... > > Erm. Well, as this is a major upgrade where we can affect people's > > conf and > > break old things & so on, I'll jump in this discussion with a > > wishlist to > > discuss :) > > > > I made sure we're tracking all these (links bel

Re: [ClusterLabs] Planning for Pacemaker 3

2024-01-23 Thread Jehan-Guillaume de Rorthais via Users
Hi there ! On Wed, 03 Jan 2024 11:06:27 -0600 Ken Gaillot wrote: > Hi all, > > I'd like to release Pacemaker 3.0.0 around the middle of this year. > I'm gathering proposed changes here: > > https://projects.clusterlabs.org/w/projects/pacemaker/pacemaker_3.0_changes/ > > Please review for an

Re: [ClusterLabs] how to colocate promoted resources ?

2023-12-08 Thread Jehan-Guillaume de Rorthais via Users
On Fri, 8 Dec 2023 17:11:58 +0100 lejeczek via Users wrote: ... > Apologies, perhaps I was quite vague. > I was thinking - having a 3-node HA cluster and 3-node > single-master->slaves pgSQL, now.. > say, I want pgSQL masters to spread across HA cluster so I > theory - having each HA node identi

Re: [ClusterLabs] how to colocate promoted resources ?

2023-12-08 Thread Jehan-Guillaume de Rorthais via Users
Hi, On Wed, 6 Dec 2023 10:36:39 +0100 lejeczek via Users wrote: > How do your colocate your promoted resources with balancing > underlying resources as priority? What do you mean? > With a simple scenario, say > 3 nodes and 3 pgSQL clusters > what would be best possible way - I'm thinking mos

Re: [ClusterLabs] PAF / pgSQL fails after OS/system shutdown - FIX

2023-11-13 Thread Jehan-Guillaume de Rorthais via Users
On Fri, 10 Nov 2023 20:34:40 +0100 lejeczek via Users wrote: > On 10/11/2023 18:16, Jehan-Guillaume de Rorthais wrote: > > On Fri, 10 Nov 2023 17:17:41 +0100 > > lejeczek via Users wrote: > > > > ... > >>> Of course you can use "pg_stat_tmp", just make sure the temp folder > >>> exists: > >>>

Re: [ClusterLabs] [EXT] Re: PAF / pgSQL fails after OS/system shutdown - FIX

2023-11-13 Thread Jehan-Guillaume de Rorthais via Users
n your cluster. Thoughts? > -Original Message----- > From: Users On Behalf Of Jehan-Guillaume de > Rorthais via Users Sent: Friday, November 10, 2023 1:13 PM > To: lejeczek via Users > Cc: Jehan-Guillaume de Rorthais > Subject: [EXT] Re: [ClusterLabs] PAF / pgSQL fails after

Re: [ClusterLabs] PAF / pgSQL fails after OS/system shutdown - FIX

2023-11-10 Thread Jehan-Guillaume de Rorthais via Users
On Fri, 10 Nov 2023 17:17:41 +0100 lejeczek via Users wrote: ... > > Of course you can use "pg_stat_tmp", just make sure the temp folder exists: > > > >cat < /etc/tmpfiles.d/postgresql-part.conf > ># Directory for PostgreSQL temp stat files > >d /var/run/postgresql/14-paf.pg_stat_tmp

Re: [ClusterLabs] PAF / pgSQL fails after OS/system shutdown - FIX

2023-11-10 Thread Jehan-Guillaume de Rorthais via Users
On Fri, 10 Nov 2023 12:27:24 +0100 lejeczek via Users wrote: ... > > > to share my "fix" for it - perhaps it was introduced by > OS/packages (Ubuntu 22) updates - ? - as oppose to resource > agent itself. > > As the logs point out - pg_stat_tmp - is missing and from > what I see it's only th

Re: [ClusterLabs] PAF / PGSQLMS and wal_level ?

2023-09-13 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 13 Sep 2023 17:32:01 +0200 lejeczek via Users wrote: > On 08/09/2023 17:29, Jehan-Guillaume de Rorthais wrote: > > On Fri, 8 Sep 2023 16:52:53 +0200 > > lejeczek via Users wrote: > > > >> Hi guys. > >> > >> Before I start fiddling and brake things I wonder if > >> somebody knows if: >

Re: [ClusterLabs] PAF / PGSQLMS and wal_level ?

2023-09-08 Thread Jehan-Guillaume de Rorthais via Users
On Fri, 8 Sep 2023 16:52:53 +0200 lejeczek via Users wrote: > Hi guys. > > Before I start fiddling and brake things I wonder if > somebody knows if: > pgSQL can work with: |wal_level = archive for PAF ? > Or more general question with pertains to ||wal_level - can > _barman_ be used with pgSQL

Re: [ClusterLabs] PAF / PGSQLMS on Ubuntu

2023-09-08 Thread Jehan-Guillaume de Rorthais via Users
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

Re: [ClusterLabs] OCF_HEARTBEAT_PGSQL - any good with current Postgres- ?

2023-05-05 Thread Jehan-Guillaume de Rorthais via Users
On Fri, 5 May 2023 10:08:17 +0200 lejeczek via Users wrote: > On 25/04/2023 14:16, Jehan-Guillaume de Rorthais wrote: > > Hi, > > > > On Mon, 24 Apr 2023 12:32:45 +0200 > > lejeczek via Users wrote: > > > >> I've been looking up and fiddling with this RA but > >> unsuccessfully so far, that I

Re: [ClusterLabs] OCF_HEARTBEAT_PGSQL - any good with current Postgres- ?

2023-04-25 Thread Jehan-Guillaume de Rorthais via Users
Hi, On Mon, 24 Apr 2023 12:32:45 +0200 lejeczek via Users wrote: > I've been looking up and fiddling with this RA but > unsuccessfully so far, that I wonder - is it good for > current versions of pgSQLs? As far as I know, the pgsql agent is still supported, last commit on it happen in Jan 11t

Re: [ClusterLabs] [PaceMaker] Help troubleshooting frequent disjoin issue

2023-03-21 Thread Jehan-Guillaume de Rorthais via Users
On Tue, 21 Mar 2023 11:47:23 +0100 Jérôme BECOT wrote: > Le 21/03/2023 à 11:00, Jehan-Guillaume de Rorthais a écrit : > > Hi, > > > > On Tue, 21 Mar 2023 09:33:04 +0100 > > Jérôme BECOT wrote: > > > >> We have several clusters running for different zabbix components. Some > >> of these cluster

Re: [ClusterLabs] [PaceMaker] Help troubleshooting frequent disjoin issue

2023-03-21 Thread Jehan-Guillaume de Rorthais via Users
Hi, On Tue, 21 Mar 2023 09:33:04 +0100 Jérôme BECOT wrote: > We have several clusters running for different zabbix components. Some > of these clusters consist of 2 zabbix proxies,where nodes run Mysql, > Zabbix-proxy server and a VIP, and a corosync-qdevice. I'm not sure to understand your

Re: [ClusterLabs] [External] : Reload DNSMasq after IPAddr2 change ?

2023-02-10 Thread Jehan-Guillaume de Rorthais via Users
Hi, What about using the Dummy resource agent (ocf_heartbeat_dummy(7)) and collocate it with your IP address? This RA creates a local file on start and removes it on stop. The game now is to watch for this path from a systemd path unit and trigger the reload when file appears. See systemd.path(5).

[ClusterLabs] Resource validation [was: multiple resources - pgsqlms - and IP(s)]

2023-01-09 Thread Jehan-Guillaume de Rorthais via Users
Hi, I definitely have some work/improvements to do on the pgsqlms agent, but there's still some details I'm interested to discuss below. On Fri, 6 Jan 2023 16:36:19 -0800 Reid Wahl wrote: > On Fri, Jan 6, 2023 at 3:26 PM Jehan-Guillaume de Rorthais via Users > wrote: >>

Re: [ClusterLabs] multiple resources - pgsqlms - and IP(s)

2023-01-06 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 4 Jan 2023 11:15:06 +0100 Tomas Jelinek wrote: > Dne 04. 01. 23 v 8:29 Reid Wahl napsal(a): > > On Tue, Jan 3, 2023 at 10:53 PM lejeczek via Users > > wrote: > >> > >> > >> > >> On 03/01/2023 21:44, Ken Gaillot wrote: > >>> On Tue, 2023-01-03 at 18:18 +0100, lejeczek via Users wrote:

Re: [ClusterLabs] multiple resources - pgsqlms - and IP(s)

2023-01-03 Thread Jehan-Guillaume de Rorthais via Users
Hi, On Tue, 3 Jan 2023 16:44:01 +0100 lejeczek via Users wrote: > To get/have Postgresql cluster with 'pgsqlms' resource, such > cluster needs a 'master' IP - what do you guys do when/if > you have multiple resources off this agent? > I wonder if it is possible to keep just one IP and have all

Re: [ClusterLabs] [External] : Re: Fence Agent tests

2022-11-07 Thread Jehan-Guillaume de Rorthais via Users
On Mon, 7 Nov 2022 14:06:51 + Robert Hayden wrote: > > -Original Message- > > From: Users On Behalf Of Valentin Vidic > > via Users > > Sent: Sunday, November 6, 2022 5:20 PM > > To: users@clusterlabs.org > > Cc: Valentin Vidić > > Subject: Re: [ClusterLabs] [External] : Re: Fence A

Re: [ClusterLabs] [External] : Re: Fence Agent tests

2022-11-05 Thread Jehan-Guillaume de Rorthais via Users
On Sat, 5 Nov 2022 20:54:55 + Robert Hayden wrote: > > -Original Message- > > From: Jehan-Guillaume de Rorthais > > Sent: Saturday, November 5, 2022 3:45 PM > > To: users@clusterlabs.org > > Cc: Robert Hayden > > Subject: Re: [ClusterLabs] [External] : Re: Fence Agent tests > > > >

Re: [ClusterLabs] [External] : Re: Fence Agent tests

2022-11-05 Thread Jehan-Guillaume de Rorthais via Users
On Sat, 5 Nov 2022 20:53:09 +0100 Valentin Vidić via Users wrote: > On Sat, Nov 05, 2022 at 06:47:59PM +, Robert Hayden wrote: > > That was my impression as well...so I may have something wrong. My > > expectation was that SBD daemon should be writing to the /dev/watchdog > > within 20 secon

Re: [ClusterLabs] Corosync over dedicated interface?

2022-10-03 Thread Jehan-Guillaume de Rorthais via Users
On Mon, 3 Oct 2022 14:45:49 +0200 Tomas Jelinek wrote: > Dne 28. 09. 22 v 18:22 Jehan-Guillaume de Rorthais via Users napsal(a): > > Hi, > > > > A small addendum below. > > > > On Wed, 28 Sep 2022 11:42:53 -0400 > > "Kevin P. Fleming" wrote:

Re: [ClusterLabs] Corosync over dedicated interface?

2022-09-28 Thread Jehan-Guillaume de Rorthais via Users
Hi, A small addendum below. On Wed, 28 Sep 2022 11:42:53 -0400 "Kevin P. Fleming" wrote: > On Wed, Sep 28, 2022 at 11:37 AM Dave Withheld > wrote: > > > > Is it possible to get corosync to use the private network and stop trying > > to use the LAN for cluster communications? Or am I totally of

Re: [ClusterLabs] DRBD and SQL Server

2022-09-28 Thread Jehan-Guillaume de Rorthais via Users
On Wed, 28 Sep 2022 02:33:59 -0400 Madison Kelly wrote: > ... > I'm happy to go into more detail, but I'll stop here until/unless you have > more questions. Otherwise I'd write a book. :) I would buy it ;) ___ Manage your subscription: https://lists.cl

Re: [ClusterLabs] (no subject)

2022-09-07 Thread Jehan-Guillaume de Rorthais via Users
Hey, On Wed, 7 Sep 2022 19:12:53 +0900 권오성 wrote: > Hello. > I am a student who wants to implement a redundancy system with raspberry pi. > Last time, I posted about how to proceed with installation on raspberry pi > and received a lot of comments. > Among them, I searched a lot after looking at