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

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

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,

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. > >>

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

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

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

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

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
t; -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 OS/system shutdown - > FIX

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

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

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

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

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

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

[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

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

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

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

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

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:

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