Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 34E289F938C for ; Wed, 3 Jan 2007 03:29:44 -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 54555-10 for ; Wed, 3 Jan 2007 03:29:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 700779F9312 for ; Wed, 3 Jan 2007 03:29:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mx.imatech.net (unknown [81.255.215.253]) by svr4.postgresql.org (Postfix) with ESMTP id C33B85AF889 for ; Wed, 3 Jan 2007 07:29:37 +0000 (GMT) X-AuthUser: olivier.boissard@cerene.fr Received: from [200.200.200.34] ([195.6.193.141]:38876) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Wed, 3 Jan 2007 08:29:28 +0100 Message-ID: <459B5B63.5080903@cerene.fr> Date: Wed, 03 Jan 2007 08:29:39 +0100 From: Olivier Boissard Organization: cerene services User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Guillaume Lelarge Cc: pgsql-admin@postgresql.org Subject: Re: table comparison References: <458B8FAA.8040104@cerene.fr> <4595A2C5.7060606@lelarge.info> In-Reply-To: <4595A2C5.7060606@lelarge.info> Content-Type: multipart/mixed; boundary="------------090707050809090904000100" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/7 X-Sequence-Number: 24163 This is a multi-part message in MIME format. --------------090707050809090904000100 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Guillaume Lelarge a écrit : > 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. > > > Thanks for your response. I didn't know anything about these 2 products before. They seem to be very interesting erven if I would prefer free product. Do you know if they are easy to use ? Olivier --------------090707050809090904000100 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 --------------090707050809090904000100--