Re: High availability and load balancing ...

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: High availability and load balancing ...
Дата
Msg-id CAEyp7J-zHkqMuqtff=6_5-_SeouKTXH+wsJGLohqub1ZioQ-wQ@mail.gmail.com
обсуждение исходный текст
Ответ на High availability and load balancing ...  (Sunil N Shinde <Sunil.Shinde@mastek.com>)
Ответы Re: High availability and load balancing ...  (Sunil N Shinde <Sunil.Shinde@mastek.com>)
Список pgsql-general
Дерево обсуждения

 

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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: WAL's listing in pg_xlog by some sql query
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: High availability and load balancing ...