Re: Patch: Implement failover on libpq connect level.

Поиск
Список
Период
Сортировка
Искать
От
Craig Ringer
Тема
Re: Patch: Implement failover on libpq connect level.
Дата
Msg-id
CAMsr+YGuaHDee-8dEn0iH4Vs28WngDxxrQkHJ_H4WSQXFoKf8w@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Tatsuo Ishii <ishii@postgresql.org>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Tatsuo Ishii <ishii@postgresql.org>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Tom Lane <tgl@sss.pgh.pa.us>
Discussion summary: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Patch (2): Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch (2): Implement failover on libpq connect level. Korry Douglas <korry.douglas@enterprisedb.com>
Re: Patch (2): Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch (2): Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch (2): Implement failover on libpq connect level. Peter Eisentraut <peter_e@gmx.net>
Re: Patch (2): Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch (2): Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch (2): Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch (2): Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch (2): Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Patch (3): Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch (3): Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch (3): Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch (3): Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter_e@gmx.net>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter_e@gmx.net>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter_e@gmx.net>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter_e@gmx.net>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Craig Ringer <craig@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter_e@gmx.net>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Craig Ringer <craig@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Korry Douglas <korry.douglas@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Teodor Sigaev <teodor@sigaev.ru>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. David Steele <david@pgmasters.net>
Re: Patch: Implement failover on libpq connect level. Simon Riggs <simon@2ndQuadrant.com>
Re: Patch: Implement failover on libpq connect level. David Steele <david@pgmasters.net>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Thom Brown <thom@linux.com>
Re: Patch: Implement failover on libpq connect level. Michael Paquier <michael.paquier@gmail.com>
Re: Patch: Implement failover on libpq connect level. Korry Douglas <korry.douglas@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Christopher Browne <cbbrowne@gmail.com>
Re: Patch: Implement failover on libpq connect level. David Fetter <david@fetter.org>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Peter van Hardenberg <pvh@pvh.ca>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Catalin Iacob <iacobcatalin@gmail.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Catalin Iacob <iacobcatalin@gmail.com>
Re: Patch: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Catalin Iacob <iacobcatalin@gmail.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Kevin Grittner <kgrittn@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Craig Ringer <craig@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Craig Ringer <craig@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Patch: Implement failover on libpq connect level. Catalin Iacob <iacobcatalin@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Mithun Cy <mithun.cy@enterprisedb.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Craig Ringer <craig@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Patch: Implement failover on libpq connect level. Christopher Browne <cbbrowne@gmail.com>
Re: Patch: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Patch: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Patch: Implement failover on libpq connect level. Craig Ringer <craig@2ndquadrant.com>
Re: Patch: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Proposal: Implement failover on libpq connect level. 'Victor Wagner *EXTERN*' <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Proposal: Implement failover on libpq connect level. ''Victor Wagner *EXTERN*' *EXTERN*' <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. "Daniel Verite" <daniel@manitou-mail.org>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: Implement failover on libpq connect level. Andres Freund <andres@anarazel.de>
Re: Proposal: Implement failover on libpq connect level. Oleg Bartunov <obartunov@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Simon Riggs <simon@2ndQuadrant.com>
Re: Proposal: Implement failover on libpq connect level. ''Victor Wagner *EXTERN*' *EXTERN*' *EXTERN* <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Proposal: Implement failover on libpq connect level. Teodor Sigaev <teodor@sigaev.ru>
Re: Proposal: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Andres Freund <andres@anarazel.de>
Re: Proposal: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Stephen Frost <sfrost@snowman.net>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Proposal: Implement failover on libpq connect level. Stephen Frost <sfrost@snowman.net>
Re: Proposal: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Proposal: Implement failover on libpq connect level. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Proposal: Implement failover on libpq connect level. Stephen Frost <sfrost@snowman.net>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. "Shulgin, Oleksandr" <oleksandr.shulgin@zalando.de>
Re: Proposal: Implement failover on libpq connect level. Christopher Browne <cbbrowne@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Bruce Momjian <bruce@momjian.us>
Re: Proposal: Implement failover on libpq connect level. Kevin Grittner <kgrittn@ymail.com>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Kevin Grittner <kgrittn@ymail.com>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Dave Page <dpage@pgadmin.org>
Re: Proposal: Implement failover on libpq connect level. Christopher Browne <cbbrowne@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Magnus Hagander <magnus@hagander.net>
Re: Proposal: Implement failover on libpq connect level. David Fetter <david@fetter.org>
Re: Proposal: Implement failover on libpq connect level. Amit Kapila <amit.kapila16@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner *EXTERN* <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. PostgreSQL - Hans-Jürgen Schönig<postgres@cybertec.at>
Re: Proposal: Implement failover on libpq connect level. Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Proposal: Implement failover on libpq connect level. PostgreSQL - Hans-Jürgen Schönig<postgres@cybertec.at>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Amit Kapila <amit.kapila16@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Amit Kapila <amit.kapila16@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Victor Wagner <vitus@wagner.pp.ru>
Re: Proposal: Implement failover on libpq connect level. Amit Kapila <amit.kapila16@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
Re: Proposal: Implement failover on libpq connect level. Jaime Casanova <jaime.casanova@2ndquadrant.com>
Re: Proposal: Implement failover on libpq connect level. Robert Haas <robertmhaas@gmail.com>
On 19 November 2016 at 01:29, Robert Haas  wrote:

>> We can and probably should have both.
>>
>> If the server tells us on connect whether it's a standby or not, use that.
>>
>> Otherwise, ask it.
>>
>> That way we don't pay the round-trip cost and get the log spam when
>> talking to newer servers that send us something useful in the startup
>> packet, but we can still query it on older servers. Graceful fallback.
>>
>> Every round trip is potentially very expensive. Having libpq do them
>> unnecessarily is bad.
>
> True, but raising the bar for this feature so that it doesn't get done
> is also bad.  It can be improved in a later patch.

Good point. Starting with the followup query method seems fine.


-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата:
От: Claudio Freire
Дата:
FAQ