Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9FC899FA320 for ; Fri, 29 Dec 2006 19:19:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 56631-04 for ; Fri, 29 Dec 2006 19:19:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id 4D89D9FA0B7 for ; Fri, 29 Dec 2006 19:19:19 -0400 (AST) Received: from sd-2317.dedibox.fr (localhost.localdomain [127.0.0.1]) by sd-2317.dedibox.fr (Postfix) with ESMTP id AB1D538AA; Sat, 30 Dec 2006 00:22:28 +0100 (CET) Received: from [192.168.10.65] (ASte-Genev-Bois-153-1-53-54.w81-249.abo.wanadoo.fr [81.249.147.54]) by sd-2317.dedibox.fr (Postfix) with ESMTP id DB4143702; Sat, 30 Dec 2006 00:22:27 +0100 (CET) Message-ID: <4595A2C5.7060606@lelarge.info> Date: Sat, 30 Dec 2006 00:20:37 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 1.5.0.8 (X11/20061115) MIME-Version: 1.0 To: Olivier Boissard Cc: pgsql-admin@postgresql.org Subject: Re: table comparison References: <458B8FAA.8040104@cerene.fr> In-Reply-To: <458B8FAA.8040104@cerene.fr> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/359 X-Sequence-Number: 24151 Olivier Boissard a écrit : > I'd like to compare postgresql tables content between 2 servers after a > replication. > Do you know which tools can do this ? > If you don't mind using a non-free product, there are DB Comparer for PostgreSQL (http://sqlmanager.net/fr/products/postgresql/dbcomparer) and Data Comparer for PostgreSQL (http://sqlmanager.net/fr/products/postgresql/datacomparer), both from EMS. They have great tools for databases. Regards. -- Guillaume.