Hi all,
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
Hi Arjen Roodselaar,
There exist some diff tools:
- apgdiff http://apgdiff.sourceforge.net/
- pgdiff http://pgdiff.sourceforge.net/
or your home-made diff tool.
Regards,
Christophe Philemotte
On Thu, Mar 4, 2010 at 11:19 AM, Arjen Roodselaar ar...@lindix.nl wrote:
Hi all,
I recently
There exist some diff tools:
- apgdiff http://apgdiff.sourceforge.net/
- pgdiff http://pgdiff.sourceforge.net/
Those are schema-wise. I think that Arjen means data-wise.
you're rigth, I do not know data-wise diff. In fact, I've developped
my solution to check if backends are synchronized or
Le 04/03/2010 13:41, Christophe Philemotte a écrit :
There exist some diff tools:
- apgdiff http://apgdiff.sourceforge.net/
- pgdiff http://pgdiff.sourceforge.net/
Those are schema-wise. I think that Arjen means data-wise.
you're rigth, I do not know data-wise diff. In fact, I've developped
gt; gt;gt; There exist some diff tools:
gt; gt;gt; - apgdiff http://apgdiff.sourceforge.net/
gt; gt;gt; - pgdiff http://pgdiff.sourceforge.net/
gt; gt;
gt; gt; Those are schema-wise. I think that Arjen means data-wise.
gt; you're rigth, I do not know data-wise diff. In fact, I've developped
gt; my
Hi Tatsuo,
I did some more debug, and it seems the problem I had is solved. But there
is still a problem.
The test I did is:
1) Start postgres node2
2) Start postgres node1
3) start pgpool (node1)
4) From a remote terminal (client1):
for i in $(seq 0 2000); do { echo $(date +%H:%M:%S); psql -d
1) Start postgres node2
2) Start postgres node1
3) start pgpool (node1)
4) From a remote terminal (client1):
for i in $(seq 0 2000); do { echo $(date +%H:%M:%S); psql
-d database -p
-h 192.168.1.5 -U postgres -c insert into pri values
($i, 'nom$i');;
echo $i; sleep 1; }; done
5)
Daniel,
Looks like interrupted connect() ought to check if SIGQUIT has been
delivered. Will check. I have no time until next week though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Hi Tatsuo,
I did some more debug, and