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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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"

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

On Thu, Jun 9, 2016 at 8:01 PM, Sunil N Shinde <Sunil.Shinde@mastek.com>
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 version
9.5 is a lot better with a lot of bug fixes specific to streaming
replication and with a few extra parameters compared to the version 9.1.
Please refer to postgresql documentation.

Regards,

Venkata B N
Fujitsu Australia