X-Original-To: pgsql-hackers-pitr-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2307DD1BA8F; Tue, 9 Mar 2004 23:10:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96246-01; Tue, 9 Mar 2004 19:10:17 -0400 (AST) Received: from cmailm5.svr.pol.co.uk (cmailm5.svr.pol.co.uk [195.92.193.21]) by svr1.postgresql.org (Postfix) with ESMTP id 5060AD1CAE3; Tue, 9 Mar 2004 19:10:13 -0400 (AST) Received: from modem-2193.lynx.dialup.pol.co.uk ([217.135.200.145] helo=LaptopDellXP) by cmailm5.svr.pol.co.uk with esmtp (Exim 4.14) id 1B0qMZ-0005zg-8w; Tue, 09 Mar 2004 23:10:15 +0000 Reply-To: From: "Simon Riggs" To: Cc: Subject: PITR: Request for assistance with alpha test plan Date: Tue, 9 Mar 2004 23:10:01 -0000 Organization: 2nd Quadrant Message-ID: <006d01c4062b$aa1d8c00$f3bd87d9@LaptopDellXP> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <40372FDF.5020907@bluewin.ch> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/7 X-Sequence-Number: 31 A detailed proposal has now been published for PITR functionality. I'd like to now request assistance from anybody and everybody that USEs PostgreSQL, not just hackers, to work out a well-documented and comprehensive test plan for PITR. (Some have offered, though volunteers are required, so I would not make individual requests). Regression tests currently protect PostgreSQL from a range of ugly situations. PITR will need a similarly rigorous approach, though this cannot be easily added as regression tests because of the very nature of the PITR functions and possible failure scenarios. My suggestion is the coordinated assembly of a comprehensive test plan, BY USERS, for USERS. When such a test plan document is assembled, the tests described should be able to be repeated many times by many users on many platforms, though under a range of workloads, to ensure all bugs are found and reported. This is ideally suited to those who USE rather than extend the existing functionality. You are skilled people whose contribution is gratefully received in this endeavour. Based upon the possible failures already identified, it should be possible to write a set of tests that check for those failure conditions. In doing so, it may occur to you that other failure conditions may exist also and it would be good to raise those as possibilities now. This ISN'T a call for beta-testers, but a call for assistance in assembling the list of tests that alpha-testers will be asked to complete. If you don't understand what I'm asking for, then it may not yet be time for you to help; however, I am particularly interested in assistance from those who know they are using relatively obscure parts of the PostgreSQL product. Based upon volume of response, you may not receive individual thanks...but there will be a list of credits somewhere down the line.... Best Regards, Simon Riggs