From: | Sunil N Shinde <Sunil(dot)Shinde(at)mastek(dot)com> |
---|---|
To: | Venkata Balaji N <nag1010(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: High availability and load balancing ... |
Date: | 2016-06-09 10:01:57 |
Message-ID: | KL1PR0601MB14130D86ABF689B24CF3FCADEE5F0@KL1PR0601MB1413.apcprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)com]
Sent: 08 June 2016 12:46
To: Sunil N Shinde <Sunil(dot)Shinde(at)mastek(dot)com>
Cc: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael McInness | 2016-06-09 13:07:20 | Re: connection pooling, many users, many datasources |
Previous Message | Greg Navis | 2016-06-09 08:57:11 | Re: [pg_trgm] Making similarity(?, ?) < ? use an index |