Thread: pgsql: Add a test framework for recovery

pgsql: Add a test framework for recovery

From
Alvaro Herrera
Date:
Add a test framework for recovery

This long-awaited framework is an expansion of the existing PostgresNode
stuff to support additional features for recovery testing; the recovery
tests included in this commit are a starting point that cover some of
the recovery features we have.  More scripts are expected to be added
later.

Author: Michaël Paquier, a bit of help from Amir Rohan
Reviewed by: Amir Rohan, Stas Kelvich, Kyotaro Horiguchi, Victor Wagner,
Craig Ringer, Álvaro Herrera
Discussion: http://www.postgresql.org/message-id/CAB7nPqTf7V6rswrFa=q_rrWeETUWagP=h8LX8XAov2Jcxw0DRg@mail.gmail.com
Discussion:
http://www.postgresql.org/message-id/trinity-b4a8035d-59af-4c42-a37e-258f0f28e44a-1443795007012@3capp-mailcom-lxa08

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/49148645f7f30f461b09618b5342b37425f33b22

Modified Files
--------------
doc/src/sgml/install-windows.sgml           |   4 +-
src/test/Makefile                           |   2 +-
src/test/perl/PostgresNode.pm               |  74 +++++++++++++++-
src/test/recovery/.gitignore                |   3 +
src/test/recovery/Makefile                  |  17 ++++
src/test/recovery/README                    |  21 +++++
src/test/recovery/t/001_stream_rep.pl       |  70 ++++++++++++++++
src/test/recovery/t/002_archiving.pl        |  52 ++++++++++++
src/test/recovery/t/003_recovery_targets.pl | 126 ++++++++++++++++++++++++++++
src/test/recovery/t/004_timeline_switch.pl  |  75 +++++++++++++++++
src/test/recovery/t/005_replay_delay.pl     |  49 +++++++++++
src/tools/msvc/vcregress.pl                 |  13 ++-
12 files changed, 501 insertions(+), 5 deletions(-)


Re: pgsql: Add a test framework for recovery

From
Andres Freund
Date:
On 2016-02-26 19:15:24 +0000, Alvaro Herrera wrote:
> Add a test framework for recovery
>
> This long-awaited framework is an expansion of the existing PostgresNode
> stuff to support additional features for recovery testing; the recovery
> tests included in this commit are a starting point that cover some of
> the recovery features we have.  More scripts are expected to be added
> later.

Yay!

Andres


Re: pgsql: Add a test framework for recovery

From
Thom Brown
Date:
On 26 February 2016 at 19:15, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Add a test framework for recovery
>
> This long-awaited framework is an expansion of the existing PostgresNode
> stuff to support additional features for recovery testing; the recovery
> tests included in this commit are a starting point that cover some of
> the recovery features we have.  More scripts are expected to be added
> later.
>
> Author: Michaël Paquier, a bit of help from Amir Rohan
> Reviewed by: Amir Rohan, Stas Kelvich, Kyotaro Horiguchi, Victor Wagner,
> Craig Ringer, Álvaro Herrera
> Discussion: http://www.postgresql.org/message-id/CAB7nPqTf7V6rswrFa=q_rrWeETUWagP=h8LX8XAov2Jcxw0DRg@mail.gmail.com
> Discussion:
http://www.postgresql.org/message-id/trinity-b4a8035d-59af-4c42-a37e-258f0f28e44a-1443795007012@3capp-mailcom-lxa08
>
> Branch
> ------
> master
>
> Details
> -------
> http://git.postgresql.org/pg/commitdiff/49148645f7f30f461b09618b5342b37425f33b22
>
> Modified Files
> --------------
> doc/src/sgml/install-windows.sgml           |   4 +-
> src/test/Makefile                           |   2 +-
> src/test/perl/PostgresNode.pm               |  74 +++++++++++++++-

One typo in this one:

s/passiong/passing/

Thom


Re: pgsql: Add a test framework for recovery

From
Thom Brown
Date:
On 26 February 2016 at 19:26, Thom Brown <thom@linux.com> wrote:
> On 26 February 2016 at 19:15, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>> Add a test framework for recovery
>>
>> This long-awaited framework is an expansion of the existing PostgresNode
>> stuff to support additional features for recovery testing; the recovery
>> tests included in this commit are a starting point that cover some of
>> the recovery features we have.  More scripts are expected to be added
>> later.
>>
>> Author: Michaël Paquier, a bit of help from Amir Rohan
>> Reviewed by: Amir Rohan, Stas Kelvich, Kyotaro Horiguchi, Victor Wagner,
>> Craig Ringer, Álvaro Herrera
>> Discussion: http://www.postgresql.org/message-id/CAB7nPqTf7V6rswrFa=q_rrWeETUWagP=h8LX8XAov2Jcxw0DRg@mail.gmail.com
>> Discussion:
http://www.postgresql.org/message-id/trinity-b4a8035d-59af-4c42-a37e-258f0f28e44a-1443795007012@3capp-mailcom-lxa08
>>
>> Branch
>> ------
>> master
>>
>> Details
>> -------
>> http://git.postgresql.org/pg/commitdiff/49148645f7f30f461b09618b5342b37425f33b22
>>
>> Modified Files
>> --------------
>> doc/src/sgml/install-windows.sgml           |   4 +-
>> src/test/Makefile                           |   2 +-
>> src/test/perl/PostgresNode.pm               |  74 +++++++++++++++-
>
> One typo in this one:
>
> s/passiong/passing/

Oh, I see you caught it.

Thom


Re: pgsql: Add a test framework for recovery

From
Alvaro Herrera
Date:
Thom Brown wrote:

> > One typo in this one:
> >
> > s/passiong/passing/
>
> Oh, I see you caught it.

Actually Craig did, but yeah :-)

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services