How to setup clustering in Postgresql?

May 24, 2016 683 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:
https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-6

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.