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
Ответ на
Re: Patch: Implement failover on libpq connect level. (Robert Haas)
Список
Дерево обсуждения
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
Дата: