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

For@ll forall at stalowka.info
Fri Dec 9 03:43:25 JST 2011


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/1be60072/attachment.html>


More information about the pgpool-general mailing list