[pgpool-general: 74] Re: Pgpool + streaming replication

For@ll forall at stalowka.info
Fri Dec 9 05:03:52 JST 2011


W dniu 2011-12-08 20:06, Lazaro Rubén García Martinez pisze:
>
> You can rename the functions that use temporary tables adding a 
> prefix, for instance:
>
> fun_tmp.................
>
> and then you need modify the parameter black_function_list of 
> pgpool.conf like this:
>
> black_function_list = 'currval,lastval,nextval,setval,fun_tmp.*'
>
> As the result, all these functions will be execute only in the primary 
> server , but remember, you need to connect with the database through 
> pgpool-II.
>
> Regards.
>
>
In my case the query it will be sent only to primary server so I can't 
use a secondary server.
Yes, I understand,  but our idea it was send a queries to both servers.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20111208/d1f96438/attachment.html>


More information about the pgpool-general mailing list