Libpq support to connect to standby server as priority

Поиск
Список
Период
Сортировка
От Jing Wang
Тема Libpq support to connect to standby server as priority
Дата
Msg-id CAF3+xMJRdKWBtnat4akRNnLL-zQn=GJ8UYj7zNKb_+6KcyuvYA@mail.gmail.com
обсуждение исходный текст
Ответы RE: Libpq support to connect to standby server as priority
Re: Libpq support to connect to standby server as priority
Список pgsql-hackers
Hi Hackers,

This is a proposal that let libpq support 'prefer-read' option in target_session_attrs in pg_conn. The 'prefer-read' means the libpq will try to connect to a 'read-only' server firstly from the multiple server addresses. If failed to connect to the 'read-only' server then it will try to connect to the 'read-write' server.

By providing this feature the application can have the opportunity to connect to the standby server firstly if failed then connect to master server without caring the sequence of the server addresses provided to the libpq.

The 'read-only' server means Standby Server
The 'read-write' server means Master Server support to 'read-write'


--
Regards,
Jing Wang
Fujitsu Australia

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Observations in Parallel Append
Следующее
От: Haribabu Kommi
Дата:
Сообщение: Re: [HACKERS] Pluggable storage