Обсуждение: High availability and load balancing ...
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
OS -- Linux 6
Thanks & Regards,
Sunil N Shinde
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
OS -- Linux 6
> 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? http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html It's a little bit out dated but mostly useful for a configuration using the latest pgpool-II version and PostgreSQL 9.1. If you have further questions regarding pgpool-II, I recommend you to move pgpool-II specific mailing list. http://www.pgpool.net/mailman/listinfo/pgpool-general > Database -- Postgresql 9.1 > OS -- Linux 6 > > > Thanks & Regards, > Sunil N Shinde Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
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: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"
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
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?