Comments on How To Set Up An Active/Passive PostgreSQL Cluster With Pacemaker, Corosync, And DRBD (CentOS 5.5)

How To Set Up An Active/Passive PostgreSQL Cluster With Pacemaker, Corosync, And DRBD (CentOS 5.5) This article explains how to set up (and monitor) an Active/Passive PostgreSQL Cluster, using Pacemaker with Corosync and DRBD. We use two nodes, one active (that answers requests from apps) and the other on passive mode. If the active server is down, the passive one will automatically take its position (being the active node). We are using the CentOS 5.5 (64bits) distribution, but it will probably work on Fedora (and Red Hat, for sure) as well.

5 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By:

Very nice and happily confirms that my solution (although using Debian Lenny) was spot on.

Also very cool to see some additional tools mentioned (zabbix f.i.)

Thanks for the efforts!

 

One word though to anyone using the HA stuff, there are some versions that can be 'complicated' so watch out and if possible, use known working versions.

By: Serge Dubrouski

Nice work!

Could you place it to the Clusterlabs' HowTo page? There is a basic HowTo for PostgreSQL that I created earlier, it would be good to replace it with yours.

By: Gergely Polonkai

Dear everyone, 

please stop disabling SELinux. It is good, and works more than fine. If you really have trouble with it, set it to permissive mode, and create a custom house rule for that. Most importantly, if you use packages from the central CentOS/Fedora/RedHad repository, report these troubles so they can add the required changes to their policies.

It's a nice article, though, it goes through every necessary steps, thank you!

Best wishes!

Gergely

By: FattahRozzaq

Very nice tutorial. I use your article to help me build PGSQL cluster using Postgres-XC (PGXC).

Would you show me to use the crm with PGXC?

(Because I don't use the standard PostgreSQL server, I use Postgres-XC).

 

Thank you in advance!

FattahRozzaq

By: Jasmin

Thank you so much for this great detailed tutorial.

I'm having toruble with configuring resources for cluster. Since I'm on RHEL 6.7 there are newer versions of pacemaker and corosync and now configuring is done with pcs instead of crm. It has different syntax.

Is there any possibility someone can help with that.

i.e.

how would this command go with pcs

crm configure ms ms_drbd_postgres drbd_postgres \  meta master-max="1" master-node-max="1" \  clone-max="2" clone-node-max="1" \  notify="true"