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

[Lazaro Rubén García Martinez]

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.

De: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] En nombre de Albert
Enviado el: jueves, 08 de diciembre de 2011 09:18
Para: Sandeep Thakkar
CC: pgpool-general at pgpool.net
Asunto: [?? Probable Spam] [pgpool-general: 64] Re: Pgpool + streaming replication

W dniu 08.12.2011 12:54, Sandeep Thakkar pisze:
According to the docs (http://pgpool.projects.postgresql.org/NEWS.txt),
"In master/slave mode, SELECTs to temporary table executes only on master/primary"



I have a pgpool 3.1 but this features is available in 3.0 pgpool, so why isn't work?
One of our programmers said "90% query using temporary tables".
So this is pgpool problem wheter our query application?


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