Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2644E9F9F46 for ; Sat, 23 Dec 2006 13:35:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 81218-04 for ; Sat, 23 Dec 2006 13:35:12 -0400 (AST) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 3EC059F939E for ; Sat, 23 Dec 2006 13:35:13 -0400 (AST) Received: from localhost (unknown [200.46.204.187]) by hub.org (Postfix) with ESMTP id 598C5118B618 for ; Sat, 23 Dec 2006 13:35:12 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 07461-05 for ; Sat, 23 Dec 2006 13:35:07 -0400 (AST) Received: from ganymede.hub.org (blk-137-79-174.eastlink.ca [24.137.79.174]) by hub.org (Postfix) with ESMTP id 30067118B5F8 for ; Sat, 23 Dec 2006 13:35:07 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id C7E6B3400C; Sat, 23 Dec 2006 13:35:07 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id C70E433EA7 for ; Sat, 23 Dec 2006 13:35:07 -0400 (AST) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.3.7) with LMTPA; Fri, 22 Dec 2006 04:00:17 -0400 X-Sieve: CMU Sieve 2.3 X-Received: from ganymede.hub.org (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id DB9D95DC8D for ; Fri, 22 Dec 2006 04:00:12 -0400 (AST) X-Received: from mail.postgresql.org [200.46.204.71] by ganymede.hub.org with IMAP (fetchmail-6.3.5) for (single-drop); Fri, 22 Dec 2006 04:00:12 -0400 (AST) X-Received: from postgresql.org ([unix socket]) by postgresql.org (Cyrus v2.3.7) with LMTPA; Fri, 22 Dec 2006 03:56:31 -0400 X-Sieve: CMU Sieve 2.3 X-Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AC4B59F9A72 for ; Fri, 22 Dec 2006 03:56:31 -0400 (AST) X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 49277-04 for ; Fri, 22 Dec 2006 03:56:31 -0400 (AST) X-Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id 4F5FD9F9312 for ; Fri, 22 Dec 2006 03:56:31 -0400 (AST) X-Original-To: pgsql-admin-postgresql.org-owner@postgresql.org X-Delivered-To: pgsql-admin-postgresql.org-owner@postgresql.org X-Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 68D2F9F9A72 for ; Fri, 22 Dec 2006 03:56:30 -0400 (AST) X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 71894-09 for ; Fri, 22 Dec 2006 03:56:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8792A9F9312 for ; Fri, 22 Dec 2006 03:56:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 X-Received: from mx.imatech.net (mx.imatech.net [81.255.215.253]) by svr4.postgresql.org (Postfix) with ESMTP id CF1735AF8A7 for ; Fri, 22 Dec 2006 07:56:24 +0000 (GMT) X-AuthUser: olivier.boissard@cerene.fr X-Received: from [200.200.200.34] ([195.6.193.141]:57120) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Fri, 22 Dec 2006 08:56:13 +0100 Message-ID: <458B8FAA.8040104@cerene.fr> Date: Fri, 22 Dec 2006 08:56:26 +0100 From: Olivier Boissard Organization: cerene services User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-admin-owner@postgresql.org Subject: table comparison Content-Type: multipart/mixed; boundary="------------020302020401020606060505" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 ReSent-Date: Sat, 23 Dec 2006 13:35:03 -0400 (AST) ReSent-From: "Marc G. Fournier" ReSent-To: pgsql-admin@postgresql.org ReSent-Subject: table comparison ReSent-Message-ID: <20061223133503.T37883@ganymede.hub.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200612/356 X-Sequence-Number: 24148 This is a multi-part message in MIME format. --------------020302020401020606060505 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello I'd like to compare postgresql tables content between 2 servers after a replication. Do you know which tools can do this ? I tried pg_comparator but not succeed to make it running. When I wrote replication , I 'd to tell you that I made my own scripts to do it as I don't know how to do it correctly with pgsql tools. I am writing a php script to compare content but I am noty sure it's the best solution .... Have anyone some ideas about this topic ? Thanks Olivier --------------020302020401020606060505 Content-Type: text/x-vcard; charset=utf-8; name="olivier.boissard.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="olivier.boissard.vcf" begin:vcard fn:Olivier Boissard n:Boissard;Olivier org:Cerene Services adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France email;internet:olivier.boissard@cerene.fr tel;work:03.25.74.11.78 tel;fax:03.25.78.39.67 version:2.1 end:vcard --------------020302020401020606060505--