Cluster fencing tool/software for PostgreSQL cluster with streaming replication

Hi Vikas!

I used to see you on the mailing list for another database, that shall
remain unnamed but starts with the letter "O". To answer your question:
I have very good experience with Veritas Cluster on both Linux and
Solaris (or was it Slowaris? I forgot the exact spelling :). It's an
industry standard fail-over cluster and Veritas provides an excellent
support for it.

Regards

On 8/16/21 6:31 AM, Vikas Sharma wrote:

Hi,

I am planning for an enterprise grade PostgreSQL cluster and so
looking for the tool/softwares which will do the cluster management or
fencing to avoid split brain.

Please, could you let me know if there are some tools/software which
can do that so it can be used in a production environment.

PostgreSQL12 with streaming replication + repmgr and pgpool for
connection management and load balancing.

Regards
Vikas S

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

On Mon, Aug 16, 2021 at 10:39:34AM -0400, Mladen Gogala wrote:

Hi Vikas!

I used to see you on the mailing list for another database, that shall
remain unnamed but starts with the letter "O". To answer your question: I
have very good experience with Veritas Cluster on both Linux and Solaris (or
was it Slowaris? I forgot the exact spelling :). It's an industry standard
fail-over cluster and Veritas provides an excellent support for it.

Uh, somehow Vikas Sharma <shavikas@gmail.com> got removed from this email
reply; I am adding him here.

---------------------------------------------------------------------------

Regards

On 8/16/21 6:31 AM, Vikas Sharma wrote:

Hi,

I am planning for an enterprise grade PostgreSQL cluster and so looking
for the tool/softwares which will do the cluster management or fencing
to avoid split brain.

Please, could you let me know if there are some tools/software which can
do that so it can be used in a production environment.

PostgreSQL12 with streaming replication + repmgr and pgpool for
connection management and load balancing.

Regards
Vikas S

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

On Mon, 16 Aug 2021 11:31:23 +0100
Vikas Sharma <shavikas@gmail.com> wrote:

Hi,

I am planning for an enterprise grade PostgreSQL cluster and so looking for
the tool/softwares which will do the cluster management or fencing to avoid
split brain.

Look at Pacemaker, pro support and devel by both RedHat and Suse.

Depending on the stack you want to build, you might want to use the pgsql
official resource agent or PAF (https://clusterlabs.github.io/PAF/). This
specific agent might not be supported by RH/Suse though.

Regards,