Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2B85164FD2D for ; Mon, 20 Oct 2008 06:03:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68856-01 for ; Mon, 20 Oct 2008 06:03:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136021.authsmtp.net (outmail136021.authsmtp.net [62.13.136.21]) by postgresql.org (Postfix) with ESMTP id D98E564FE63 for ; Mon, 20 Oct 2008 06:03:08 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt5.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m9K935AH020653; Mon, 20 Oct 2008 10:03:05 +0100 (BST) Received: from [192.168.0.3] (85-211-69-124.dyn.gotadsl.co.uk [85.211.69.124]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m9K934iX071406; Mon, 20 Oct 2008 10:03:04 +0100 (BST) Subject: Re: Strategies for validating WAL-shipping replication From: Simon Riggs To: wstrzalka Cc: pgsql-admin@postgresql.org In-Reply-To: <4cb0d791-1545-442d-888d-9fff4c2b1962@m73g2000hsh.googlegroups.com> References: <82hc77dbgz.fsf@mid.bfk.de> <4cb0d791-1545-442d-888d-9fff4c2b1962@m73g2000hsh.googlegroups.com> Content-Type: text/plain Date: Mon, 20 Oct 2008 10:05:40 +0100 Message-Id: <1224493540.3808.575.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: e7f8f0e0-9e85-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagVbYlpF HGQLW1xEUV17WWB/ aw8fZQBDYEtPQQNj TklLRk1QEQdtHhxP WxdlWxp2Lm1Gf390 ZUAsV3dfEhF9I04r QhtUCGRTbWJ9aWFL BF1QdgZRbQNKfx5N bwR8U3ReMCtlM3Bw LCYfGhEXCH1kND5c XgwCLF8JCUgMBHYi ThQDETwzHEsKDxoa C1k9Kl8EBEcXPQ0o PEMlWFkRLx4VDGUg X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200810/133 X-Sequence-Number: 30589 On Mon, 2008-10-20 at 01:08 -0700, wstrzalka wrote: > There is not such a possibility. However it's on TODO list: > http://wiki.postgresql.org/wiki/Todo > I'm waiting for this feature too. > > I can understand your fear about the data, that you can not query for > it. Please test the Hot Standby patch... -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support