Showing results for 
Search instead for 
Did you mean: 




How to configure a fail over / HA cluster with postgresql in LINUX.

Basic ideas of what is Quorom,base volumes in SANBOX
Steven E. Protter
Exalted Contributor

Re: clustering


What kind of Linux.

If you use redhat, you can use RHCS, Red Hat Clustering, which has a new qdisk(quorums feature) or you can use HP Serviceguard for Linux.

Serviceguard is pretty stable and uses the quorum disk concept.

Steven E Protter
Owner of ISN Corporation
Serviceguard for Linux
Honored Contributor

Re: clustering

Serviceguard actually has multiple quorum options. For two node clusters one is disk based and the other is network based (application runs on some third system in your environment).

Your choice :)

Re: clustering

My situiation is some thing Like this

There will be some files continuously (24*7)
uploaded to the storage box and Uploaded Files info are loaded into the Database server(Postgresql) so that i can query the infos from database server and make it in a viewable format for my WEB interface.

We are planning to put db1 and db2 as two database server in cluster with mirroring.
If i am planning for mirroring cluster will it affect my processing? will it take much time to update database continuously, because files are comming continuosly (24*7)

Help me or suggest a solution for this
Ivan Ferreira
Honored Contributor

Re: clustering

Probably, your best option is to use a shared storage with a cluster file system, like Red Hat GFS (CentOS GFS), Oracle CFS2 is also posix compliant.

Another option is to use a third server (or servers) to act as NFS servers for the database servers, and files are uploaded to the NFS servers. You can also use GNDB devices.
Por que hacerlo dificil si es posible hacerlo facil? - Why do it the hard way, when you can do it the easy way?