How to setup clustering in Postgresql?

May 24, 2016 2.3k 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

2 Answers

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

    • Hi kshitijajoshi , Did u find a way to set up PostgreSQL HA cluster ? If yes would u please guide me in setting up a 2 node high available, load balanced postgresql cluster?

Hi kshitijajoshi , Did u find a way to set up PostgreSQL HA cluster ? If yes How to configure a 2-node HA PostgreSQL cluster which load balances the requests

(both read/write requests) from the clients?

My specifications are:

OS: Ubuntu 12.04.4 LTS

PostgreSQL 9.5

Disk Size:95GB

RAM size: 8GB

Have another answer? Share your knowledge.