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:nag1010@gmail.com] Sent: 08 June 2016 12:46 To: Sunil N Shinde <Sunil.Shinde@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"