Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BD6CF64FE37 for ; Mon, 20 Oct 2008 03:31:15 -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 39431-10 for ; Mon, 20 Oct 2008 03:31:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id 9AA3F64FDA0 for ; Mon, 20 Oct 2008 03:31:12 -0300 (ADT) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1KroI7-0000t7-29 for pgsql-admin@postgresql.org; Mon, 20 Oct 2008 08:30:59 +0200 Received: from fweimer by bfk.de with local id 1KroIH-00017X-98 for pgsql-admin@postgresql.org; Mon, 20 Oct 2008 08:31:09 +0200 To: pgsql-admin@postgresql.org Subject: Strategies for validating WAL-shipping replication From: Florian Weimer Date: Mon, 20 Oct 2008 08:31:08 +0200 Message-ID: <82hc77dbgz.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable 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/130 X-Sequence-Number: 30586 We've set up WAL-shipping replication on one of our database servers, and the question is whether it runs correctly. Is there an easy way to access some tables and see if the data matches (possibly in single-user mode)? Stopping replication and starting the server for real on the replica means that we have to set up things from scratch, right? (This is a bit annoying because of the amount of data which has to be copied from the master.) --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99