Re: [GENERAL] High availability and load balancing ...

2016-06-09 Thread Venkata Balaji N
On Thu, Jun 9, 2016 at 8:01 PM, Sunil N Shinde wrote: > 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? > There is no difference in the setup. Streaming Replication in the

Re: [GENERAL] High availability and load balancing ...

2016-06-09 Thread Sunil N Shinde
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 th

Re: [GENERAL] High availability and load balancing ...

2016-06-08 Thread Tatsuo Ishii
> Hi, > > I need to do the setup for High availability function. > Also want to implement load balancing for 02 nodes. > I think PGPool will be require for that. Can I use PGPool without cost. Yes, you can. Pgpool-II is an open source product. > Can I get the basic steps to do this setup?

Re: [GENERAL] High availability and load balancing ...

2016-06-08 Thread Venkata Balaji N
> > > > 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

[GENERAL] High availability and load balancing ...

2016-06-07 Thread Sunil N Shinde
Hi, I need to do the setup for High availability function. Also want to implement load balancing for 02 nodes. I think PGPool will be require for that. Can I use PGPool without cost. Can I get the basic steps to do this setup? Database-- Postgresql 9.1