Re: Libpq support to connect to standby server as priority

Поиск
Список
Период
Сортировка
От Jing Wang
Тема Re: Libpq support to connect to standby server as priority
Дата
Msg-id CAF3+xMJnijOmLb8mhwjY7x0tWXGQDdRtSHKe7sN47FT_0T-f_g@mail.gmail.com
обсуждение исходный текст
Ответ на Libpq support to connect to standby server as priority  (Jing Wang <jingwangian@gmail.com>)
Список pgsql-hackers
Hi,

Enclosed please find the patch that the libpq support 'prefer-read' feature. 

If the target_session_attrs is set to 'prefer-read', the patch will connect to server and send 'SHOW transaction_read_only' query to check the server being 'read-only' or not. If server is 'read-write' then it will try next server address. If all connections for 'read-only' get failed it will try to connect to the master server.


--
Regards,
Jing Wang
Fujitsu Australia
Вложения

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

Предыдущее
От: Remi Colinet
Дата:
Сообщение: Re: [Patch] Make block and file size for WAL and relations defined atcluster creation
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Finalizing logical replication limitations as well as potentialfeatures