[pgpool-general: 2515] Re: black_function_list in replication mode
Tatsuo Ishii
ishii at postgresql.org
Fri Jan 31 17:37:09 JST 2014
>> Works for me. SELECTs using functions in the black_function_list
>> should be sent to all nodes.
>
> It seems as if you need to drop the database connection after changing
> the black_function_list and reloading.
>
> Yesterday, when I discovered that the function call wasn't replicated
> because it wasn't blacklisted, I was using the psql shell. I kept that
> shell while changing pgpool's config and kept using it while doing my
> (failed) replication tests afterwards.
>
> Today, I started with a fresh psql shell and now everything works as
> expected! (pgpool was neither restarted nor reloaded in the meantime.)
>
>> What do you mean by "doesn't work" exactly?
>> Can you please show the query using "tal_clonerow"?
>
> The row cloned by "select tal_clonerow('sometable',15579);" function was
> only inserted on one random backend, as checked by using local psql on
> the backend nodes. Trying to update the new entry resulted in an warning
> that a different number of rows were changed on the backend nodes.
> (We're using failover_if_affected_tuples_mismatch = false.)
> pgpool log only showed a statement line for one node, but not for other.
Reloading configuration takes effect after changing session. It's
documented in the manual.
---------------------------------------------------------------------
Please note that some configuration items cannot be changed by
reloading. New configuration takes effect after a change for new
sessions.
---------------------------------------------------------------------
>>> /*NO LOAD BALANCE*/select tal_clonerow('sometable',15579);
>>
>> Have you tried /*REPLICATION*/ comment?
>
> No.
It's documented in the manual.
> Maybe the fact that changed blacklist configs will only take effect for
> *new* database connections should be added to the documentation?
Already there.
> Anyway, thanks for your support! :-)
>
>
> Karsten
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list