Re: [ClusterLabs] PostgreSQL HA on EL9

2023-09-13 Thread Larry G. Mills via Users
> > On my RHEL 9 test cluster, both "reboot" and "systemctl reboot" wait > for the cluster to stop everything. > > I think in some environments "reboot" is equivalent to "systemctl > reboot --force" (kill all processes immediately), so maybe see if > "systemctl reboot" is better. > > > > > On

Re: [ClusterLabs] PostgreSQL HA on EL9

2023-09-13 Thread Ken Gaillot
On Wed, 2023-09-13 at 16:45 +, Larry G. Mills via Users wrote: > Hello Pacemaker community, > > I have several two-node postgres 14 clusters that I am migrating from > EL7 (Scientific Linux 7) to EL9 (AlmaLinux 9.2). > > My configuration: > > Cluster size: two nodes > Postgres version:

[ClusterLabs] PostgreSQL HA on EL9

2023-09-13 Thread Larry G. Mills via Users
Hello Pacemaker community, I have several two-node postgres 14 clusters that I am migrating from EL7 (Scientific Linux 7) to EL9 (AlmaLinux 9.2). My configuration: Cluster size: two nodes Postgres version: 14 Corosync version: 3.1.7-1.el9 Pacemaker version: 2.1.5-9.el9_2 pcs version:

Re: [ClusterLabs] MySQL cluster with auto failover

2023-09-13 Thread Ken Gaillot
On Tue, 2023-09-12 at 10:28 +0200, Damiano Giuliani wrote: > thanks Ken, > > could you point me in th right direction for a guide or some already > working configuration? > > Thanks > > Damiano Nothing specific to galera, just the usual Pacemaker Explained documentation about clones. There

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-13 Thread lejeczek via Users
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: pgSQL can work with: |wal_level = archive for PAF ? Or more general question with pertains