Re: High availability and load balancing ...

Поиск
Список
Период
Сортировка
От Sunil N Shinde
Тема Re: High availability and load balancing ...
Дата
Msg-id KL1PR0601MB14130D86ABF689B24CF3FCADEE5F0@KL1PR0601MB1413.apcprd06.prod.outlook.com
обсуждение исходный текст
Ответ на Re: High availability and load balancing ...  (Venkata Balaji N <nag1010@gmail.com>)
Ответы Re: High availability and load balancing ...  (Venkata Balaji N <nag1010@gmail.com>)
Список 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"

 

 

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

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Navis
Дата:
Сообщение: Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Следующее
От: Michael McInness
Дата:
Сообщение: Re: connection pooling, many users, many datasources