pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtable comparison
4+ messages / 2 participants
[nested] [flat]
* table comparison
@ 2006-12-22 07:56 Olivier Boissard <olivier.boissard@cerene.fr>
2006-12-29 23:20 ` Re: table comparison Guillaume Lelarge <guillaume@lelarge.info>
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-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 ` Re: table comparison 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
2006-12-22 07:56 table comparison Olivier Boissard <olivier.boissard@cerene.fr>
2006-12-29 23:20 ` Re: table comparison Guillaume Lelarge <guillaume@lelarge.info>
@ 2007-01-03 07:29 ` Olivier Boissard <olivier.boissard@cerene.fr>
2007-01-03 08:20 ` Re: table comparison 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
2006-12-22 07:56 table comparison Olivier Boissard <olivier.boissard@cerene.fr>
2006-12-29 23:20 ` Re: table comparison Guillaume Lelarge <guillaume@lelarge.info>
2007-01-03 07:29 ` Re: table comparison Olivier Boissard <olivier.boissard@cerene.fr>
@ 2007-01-03 08:20 ` Guillaume Lelarge <guillaume@lelarge.info>
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