Re: In-core regression tests for replication, cascading, archiving, PITR, etc.
От
Michael Paquier
Тема
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc.
Дата
Msg-id
CAB7nPqQk6N6J4_9OLfFfsMs9FRoK7exGOC6PNp7caLqFTzZ-Qg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. "Amir Rohan" <amir.rohan@mail.com>
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Robert Haas <robertmhaas@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Erik Rijkers <er@xs4all.nl>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Robert Haas <robertmhaas@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. David Steele <david@pgmasters.net>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Mike Blackwell <mike.blackwell@rrd.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Andrew Dunstan <andrew@dunslane.net>
Re: Re: In-core regression tests for replication, cascading, archiving, PITR, etc. Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication, cascading, archiving, PITR, etc. Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Craig Ringer <craig@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Craig Ringer <craig@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Victor Wagner <vitus@wagner.pp.ru>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Craig Ringer <craig@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Craig Ringer <craig@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Craig Ringer <craig@2ndquadrant.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: [REVIEW] In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: In-core regression tests for replication, cascading, archiving, PITR, etc. Stas Kelvich <s.kelvich@postgrespro.ru>
Re: In-core regression tests for replication, cascading,
archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: In-core regression tests for replication, cascading,
archiving, PITR, etc. Victor Wagner <vitus@wagner.pp.ru>
Re: In-core regression tests for replication, cascading,
archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: In-core regression tests for replication, cascading,
archiving, PITR, etc. Victor Wagner <vitus@wagner.pp.ru>
Re: In-core regression tests for replication, cascading, archiving,
PITR, etc. Noah Misch <noah@leadboat.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Michael Paquier <michael.paquier@gmail.com>
Re: Re: In-core regression tests for replication,
cascading, archiving, PITR, etc. Amir Rohan <amir.rohan@zoho.com>
On Sat, Oct 3, 2015 at 10:47 PM, Michael Paquier wrote: > On Sat, Oct 3, 2015 at 9:50 PM, Amir Rohan wrote: >>>> Block until recovery is finished, before testing. eliminate races, and >>>> avoid the stupid sleep(3) I used. >>> >>> TODO > > Well. I just recalled this item in the list of things you mentioned. I > marked it but forgot to address it. It sounds right that we may want > something using pg_isready in a loop as a node in recovery would > reject connections. I just hacked up an updated version with the following things: - Optional argument for stop_node to define the stop mode of pg_ctl - Addition of wait_for_node where pg_isready is used to wait until a node is ready to accept queries - Addition of a local lookup variable to track the last port assigned. This accelerates get_free_port. Regards, -- Michael
В списке pgsql-hackers по дате отправления