PostgreSQL Database Clustering

[minyi]

Hi,

Anyone got experience in doing PostgreSQL db clustering? Is it possible to achieve without any third party tools?

Thanks.

[jrmhscht]

Our DBA's use https://github.com/citusdata/pg_auto_failover to create postgres clusters.  It is active/passive, but seems to be one of the easiest ways to do it.  I haven't put IDM on the cluster yet.

[minyi]

Hi,

Thanks for the info provided. May I know if there's any pre-requisite or best practices when implement this? Besides, can this work with SAN storage?

Thanks. 

[jrmhscht]

I'm not an expert on the software so I don't know the best practices other than what is on the site.  We are using it with databases on SAN storage.  It does replicate the data between two servers so will take double the space as opposed to sharing the disk.

[minyi]

Noted and much thanks for the info provided.