Hi.
> I recently started using pgpool to add some redundancy to one of our customer
> applications. So far so good, everything seems to be working fine, but I
> would like to have some extra verification that both database servers really
> are in sync. Is there a tool available that will let me compare a given table
> on both servers and tell me if there are differences? Thanks in advance!
I don't know such a useful tools, but the following procedures enable it.
1. Lock a table of the master which wants to check consistency.
ex)
BEGIN;
LOCK TABLE <table> IN SHARE ROW EXCLUSIVE MODE;
2. Dump the table of the master and the slave.
pg_dump or copy
3. Unlock a table.
ABORT;
4. Compare the dump data
--
SRA OSS, Inc. Japan
Yoshiharu Mori <[email protected]>
http://www.sraoss.co.jp/
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
