On Thu, 2010-09-09 at 11:12 +0900, Tatsuo Ishii wrote: > > This looks good. I like the black/white lists. > > > > In load_balance_mode, if we decide to send a SELECT statement to the > > standby and it results in an ERROR, what happens? There seems to be 2 > > retryable error conditions. > > In any case currently pgpool-II returns exact same error message > returned from PostgreSQL. > > > The ERROR could be an error caused by attempt to write to the database, > > in which case we expect that the SELECT can be re-executed correctly on > > the master. > > Such errors will return 25006 READ ONLY SQL TRANSACTION > > > > The ERROR could also be caused by a Hot Standby conflict, in which case > > we can re-execute the query with some hope of later success. > > Such errors will return 40001 SERIALIZATION FAILURE > > > > Possibly somewhat late, but it would be cool to add that feature. I > > would be happy to help. > > Thanks. It's too late for 3.0 but I'm looking forward to having those > features in the future releases. Are you going to write patches for > this?
Yes, I think so. When will the next release be published? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
