pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
table comparison
4+ messages / 2 participants
[nested] [flat]

* table comparison
@ 2006-12-22 07:56  Olivier Boissard <olivier.boissard@cerene.fr>
  0 siblings, 1 reply; 4+ messages in thread

From: Olivier Boissard @ 2006-12-22 07:56 UTC (permalink / raw)
  To: pgsql-admin-owner@postgresql.org

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

Attachments:

olivier.boissard.vcf (text/x-vcard, 239B) download 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
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: table comparison
@ 2006-12-29 23:20  Guillaume Lelarge <guillaume@lelarge.info>
  parent: Olivier Boissard <olivier.boissard@cerene.fr>
  0 siblings, 1 reply; 4+ messages in thread

From: Guillaume Lelarge @ 2006-12-29 23:20 UTC (permalink / raw)
  To: Olivier Boissard <olivier.boissard@cerene.fr>; +Cc: pgsql-admin

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.
<!-- http://abs.traduc.org/
     http://lfs.traduc.org/
     http://docs.postgresqlfr.org/ -->



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: table comparison
@ 2007-01-03 07:29  Olivier Boissard <olivier.boissard@cerene.fr>
  parent: Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 4+ messages in thread

From: Olivier Boissard @ 2007-01-03 07:29 UTC (permalink / raw)
  To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-admin

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

Attachments:

olivier.boissard.vcf (text/x-vcard, 239B) download 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
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: table comparison
@ 2007-01-03 08:20  Guillaume Lelarge <guillaume@lelarge.info>
  parent: Olivier Boissard <olivier.boissard@cerene.fr>
  0 siblings, 0 replies; 4+ messages in thread

From: Guillaume Lelarge @ 2007-01-03 08:20 UTC (permalink / raw)
  To: Olivier Boissard <olivier.boissard@cerene.fr>; +Cc: pgsql-admin

Olivier Boissard a écrit :
> Guillaume Lelarge a écrit :
>>[...]
>> 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 ?
> 

Yes, they really are easy-to-use products. I would also prefer free
software but I don't know if such free tools exist.

Regards.


-- 
Guillaume.
<!-- http://abs.traduc.org/
     http://lfs.traduc.org/
     http://docs.postgresqlfr.org/ -->



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-01-03 08:20 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-22 07:56 table comparison Olivier Boissard <olivier.boissard@cerene.fr>
2006-12-29 23:20 ` Guillaume Lelarge <guillaume@lelarge.info>
2007-01-03 07:29   ` Olivier Boissard <olivier.boissard@cerene.fr>
2007-01-03 08:20     ` Guillaume Lelarge <guillaume@lelarge.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox