Thanks Venkata. I am considering latest version now i.e. 9.4 or 9.5 on Linux 6. Is there any difference in setup from 9.1 to 9.5?
Thanks & Regards, Sunil N Shinde From: Venkata Balaji N [mailto:nag1...@gmail.com] Sent: 08 June 2016 12:46 To: Sunil N Shinde <sunil.shi...@mastek.com> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] High availability and load balancing ... I need to do the setup for High availability function. Also want to implement load balancing for 02 nodes. You will have to build streaming replication which was introduced in PostgreSQL-9.0 I think PGPool will be require for that. Can I use PGPool without cost. pgpool-II is an open source tool which can be used for connection pooling and load balancing. Can I get the basic steps to do this setup? Database -- Postgresql 9.1 OS -- Linux 6 Below is the link which explains the basic steps to setup "streaming replication" https://www.postgresql.org/docs/9.1/static/warm-standby.html By the way, version 9.1 is very old and will reach end-of-life soon. You are 4 major versions behind, did you consider using latest version ? Regards, Venkata B N Fujitsu Australia