Caused by: org.postgresql.util.PSQLException: ERROR: prepared statement "S_18" does not existI guess this problem is a known bug which was fixed in 3.1. - Fix bug which cannot use the cursors of JDBC driver on standby node. The transaction commands come to be sent to all nodes by this fix in master/slave mode(Kitagawa) Does the error occur in 3.1?
Yes, it does occur in 3.1 -- that's the version I'm currently evaluating / testing.
If the error is caused by the bug, it should be solved by setting load_balance_mode to off.
One of the main drivers for us to use pgpool is to distribute the load for read transactions across our database nodes. If I turn off load_balance, doesn't pgpool stop sending selects to standby nodes?
Regards, -Bryan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
