[Pgpool-general] out of sync problem

[Marcos Davi Reis]

Hi all,My database uses pgpool with load balance with 2 servers - node 0 and
node 1.
i executed a proc that changes data in the table, calling SELECT MY_PROC()
and this caused difference between nodes because the select statement was
sent only to one node.
that problem was solved using /*replicate*/ hint.
but after the failback the data in the tables that was changed wasn't
syncronized, and the node 1 crashes everytime its data is updated.
how can i resync this tables?

tks
Davi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20091014/33641f6c/attachment.html>