Thread: table comparison

table comparison

From
Olivier Boissard
Date:
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


Attachment

Re: table comparison

From
Guillaume Lelarge
Date:
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/ -->

Re: table comparison

From
Olivier Boissard
Date:
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



Attachment

Re: table comparison

From
Guillaume Lelarge
Date:
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/ -->