How to setup clustering in Postgresql?

May 24, 2016 1.4k views
High Availability PostgreSQL Monitoring CentOS

Do I have to setup replication to have clustering setup in Postgresql? Can I not have just clustering setup in two servers.

Postgresql 9.5.0
CentOS 6.7

ps- installed postgres on two nodes following below link:

1 Answer

I am not a big Postgre user myself but doing a bit of searching found this. It sounds like Postgre only supports replication ( a couple types ) out of the box but there are third party utilities that allow you to create a clustered postgre environment.

  • Thanks ryanpg, I think I can setup just clustering without having streaming replication setup in pgsql

Have another answer? Share your knowledge.