Re: Load balancing and high availability with PostgreSQL

>From: Sunil N Shinde <Sunil(dot)Shinde(at)mastek(dot)com>
>To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
>Sent: Tuesday, June 7, 2016 5:11 AM
>Subject: [pgadmin-support] Load balancing and high availability with PostgreSQL
>
<!--#yiv1202724327 _filtered #yiv1202724327 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv1202724327 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv1202724327 #yiv1202724327 p.yiv1202724327MsoNormal, #yiv1202724327 li.yiv1202724327MsoNormal, #yiv1202724327 div.yiv1202724327MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv1202724327 a:link, #yiv1202724327 span.yiv1202724327MsoHyperlink {color:blue;text-decoration:underline;}#yiv1202724327 a:visited, #yiv1202724327 span.yiv1202724327MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv1202724327 span.yiv1202724327EmailStyle17 {font-family:"Calibri", sans-serif;color:windowtext;}#yiv1202724327 .yiv1202724327MsoChpDefault {font-family:"Calibri", sans-serif;} _filtered #yiv1202724327 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv1202724327 div.yiv1202724327WordSection1 {}-->>Hi, >
>I need to do the setup of High availability load balancing with 02 nodes. >Can you please help me in this regard by providing me the detailed steps to do this setup? >
>                Database -- Postgresql 9.1 >                OS             -- Linux 6          ?
>Thanks & Regards, >Sunil N Shinde  
>I need to do the setup of High availability load balancing with 02 nodes.

Three things.
1. This is not the mailing list for this type of question. PgAdmin is a utility for accessing PostgreSQL, it is not PostgreSQL per se.
You should instead address the pgsql-general(at)postgresql(dot)org list, but FIRST you must subscribe to that list at
https://www.postgresql.org/list/

2. These are TWO DIFFERENT items. For load balancing you will want to look at either
PgBouncer http://lists.pgfoundry.org/pipermail/pgbouncer-general/2012-April/000980.html
or
PgPool http://www.pgpool.net/docs/latest/tutorial-en.html

3. For High availablity, you should look into Replication https://www.postgresql.org/docs/9.1/static/high-availability.html
or alternatively Slony http://lists.slony.info/
or Bucardo Bucardo - Bucardo

|
|
|
| | |

|

|
|
| |
Bucardo - Bucardo
| |

|

|

 Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com