[pgpool-general: 4957] Re: Forcing all queries accessing specific table to go to master.

[Сергей Мелехин]

Hi!
You have at least two  options:
1) you can write getter and setter stored functions and add them to
black_function_list
config parameter
2) You can add comment like that: select /*nobalance*/ * from config_table;

With best regards, Sergey Melekhin


С Уважением, Сергей Мелехин.

2016-08-29 20:24 GMT+10:00 Avi Weinberg <AviW at gilat.com>:

> Hi all,
>
>
>
> We have a table that holds the configuration and for this table only we
> need to make sure we read the latest values.  All other read queries that
> access other tables can access either the master or the slave.  How can
> this be achieved automatically or otherwise.
>
>
>
> Thanks
>
> Avi
> IMPORTANT - This email and any attachments is intended for the above named
> addressee(s), and may contain information which is confidential or
> privileged. If you are not the intended recipient, please inform the sender
> immediately and delete this email: you should not copy or use this e-mail
> for any purpose nor disclose its contents to any person.
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160830/cd6df049/attachment.html>