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 по дате отправления
От: Pavel Stehule
Дата:
Сообщение: Re: check fails on Fedora 23
От: Shay Rojansky
Дата:
FAQ