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

[Lazaro Rubén García Martinez]

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.

De: For at ll [mailto:forall at stalowka.info]
Enviado el: jueves, 08 de diciembre de 2011 02:13
Para: Lazaro Rubén García Martinez
CC: Sandeep Thakkar; pgpool-general at pgpool.net
Asunto: Re: [pgpool-general: 64] Re: Pgpool + streaming replication

W dniu 2011-12-08 19:43, Lazaro Rubén García Martinez pisze:
The temporary tables are not logged in the wal, as result the temporary tables are not replicated; for this reason you cannot execute selects query over temporary tables in the standby server.
To avoid this you need to connect to the database through  Pgpool.

If the selects queries are in store procedures, you need to add the name of these procedures in black_function_list property of pgpool.conf.
Regards.


I told this to ours developers and they said  that the most functions (90%) is using a temporary tables.
They said that  functions will be rewritten so that did not use temporary tables.

Regards,

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