Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

2010-06-06 Thread Asaf Ohaion
after a couple of months of quite operation, we are getting the error pgpool detected difference of the number of inserted, updated, or deleted touples.. why isn't pgpool triggers the failover event ? it looks most rationale to me, so that users can continue to work, and sysadmin can

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

2010-06-06 Thread Ramon de Carvalho Valle
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I share the same question Asaf did. Also, if possible, it would be interesting to list all cases in which a node is detached and the failover event is triggered. - -Ramon On 06/06/2010 09:55 AM, Asaf Ohaion wrote: after a couple of months of

Re: [Pgpool-general] pgpool detected difference of the number of inserted, updated, or deleted ...etc..

2010-06-06 Thread Tatsuo Ishii
BTW : what is 'replication_stop_on_mismatch' and has it got anything to do with this issue ? replication_stop_on_mismatch only affects SELECT. So it does not anything to do with the issue. I have to admit that current document regarding replication_stop_on_mismatch is quite incorrect and hard

Re: [Pgpool-general] parallel mode ERROR: password is required, DETAIL: Non-superuser cannot connect if the server does not request a password

2010-06-06 Thread Alex
Vlad Kosilov vkosi...@... writes: solution is to give pgpool user a superuser (CREATEUSER,CREATEDB) permissions. I had the same problem when using dblink between two databases on the same host. Instead of using a superuser, I found that if you explicitly set the host, port and username, the