<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span>According to the docs (http://pgpool.projects.postgresql.org/NEWS.txt), <br></span></div><div><span></span>"In master/slave mode, SELECTs to temporary table executes only on master/primary"</div><div> </div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Albert <forall@stalowka.info><br> <b><span style="font-weight: bold;">To:</span></b> Sandeep Thakkar <sandeeptt@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, December
8, 2011 4:13 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 60] Pgpool + streaming replication<br> </font> <br>
<div id="yiv1915795060">
<div>
On 08.12.2011 11:37, Sandeep Thakkar wrote:
<blockquote type="cite">
<div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">Does <font size="-1">"sess"</font> object exists when you directly
connect to standby or primary using their ports? Or is this
problem occurs only when you execute query though pgpool port?<br>
<br>
<div style="font-family:times new roman, new york, times, serif;font-size:10pt;">
<div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <font size="2" face="Arial">
<hr size="1"> <b><span style="font-weight:bold;">From:</span></b>
Albert <a rel="nofollow" class="yiv1915795060moz-txt-link-rfc2396E" ymailto="mailto:forall@stalowka.info" target="_blank" href="mailto:forall@stalowka.info"><forall@stalowka.info></a><br>
<b><span style="font-weight:bold;">To:</span></b>
<a rel="nofollow" class="yiv1915795060moz-txt-link-abbreviated" ymailto="mailto:pgpool-general@pgpool.net" target="_blank" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a> <br>
<b><span style="font-weight:bold;">Sent:</span></b>
Thursday, December 8, 2011 3:29 PM<br>
<b><span style="font-weight:bold;">Subject:</span></b>
[pgpool-general: 60] Pgpool + streaming replication<br>
</font> <br>
<div id="yiv1915795060">
<div> <font size="-1">Hello,<br>
<br>
I testing now pgpool with streaming replication and I
have problem with temporary tables in my database.<br>
When my application try connect to standby server and
run query select I get error message e.g<br>
CETERROR: relation "sess" does not exist <br>
</font><span id="yiv1915795060result_box" class="yiv1915795060" lang="en"><span class="yiv1915795060hps"><br>
Do</span> <span class="yiv1915795060hps">PGPool</span>
<span class="yiv1915795060hps">can solve</span> <span class="yiv1915795060hps">this problem</span> <span class="yiv1915795060hps">somehow?</span></span><br>
<font size="-1"><br>
Albert<br>
</font> </div>
</div>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a rel="nofollow" ymailto="mailto:pgpool-general@pgpool.net" target="_blank" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
http://www.pgpool.net/mailman/listinfo/pgpool-general<br>
<br>
<br>
</div>
</div>
</div>
</blockquote>
'sess' temporary table is initiated after connection is made to the
database. Most probably when one of the queries is executed on
different server than master it cannot find the temporary table and
crashes. Is it possible to replicate and load balance a database
which relies on temporary tables for some of it's queries ? Are
temporary tables replicated when using postgres 9.0 streaming
replication ?<br>
<br>
Albert<br>
</div>
</div><br><br> </div> </div> </div></body></html>