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
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