[Pgpool-general] pgpool-II 3.0 RC1 released
Simon Riggs
simon at 2ndQuadrant.com
Thu Sep 9 05:58:39 UTC 2010
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
More information about the Pgpool-general
mailing list