[Pgpool-general] pgpool-II 3.0 RC1 released

[Tatsuo Ishii]

> 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?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp