Re: Load balancing and high availability with PostgreSQL
>From: Sunil N Shinde <Sunil.Shinde@mastek.com>
>To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
>Sent: Tuesday, June 7, 2016 5:11 AM
>Subject: [pgadmin-support] Load balancing and high availability with PostgreSQL
>To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
>Sent: Tuesday, June 7, 2016 5:11 AM
>Subject: [pgadmin-support] Load balancing and high availability with PostgreSQL
>
>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.
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@postgresql.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
You should instead address the pgsql-general@postgresql.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
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
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
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
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
В списке pgadmin-support по дате отправления: