<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 08.12.2011 11:37, Sandeep Thakkar wrote:
<blockquote
cite="mid:1323340632.18195.YahooMailNeo@web121718.mail.ne1.yahoo.com"
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 face="Arial" size="2">
<hr size="1"> <b><span style="font-weight:bold;">From:</span></b>
Albert <a class="moz-txt-link-rfc2396E" href="mailto:forall@stalowka.info"><forall@stalowka.info></a><br>
<b><span style="font-weight: bold;">To:</span></b>
<a class="moz-txt-link-abbreviated" 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="yiv1933934954">
<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="yiv1933934954result_box"
class="yiv1933934954" lang="en"><span
class="yiv1933934954hps"><br>
Do</span> <span class="yiv1933934954hps">PGPool</span>
<span class="yiv1933934954hps">can solve</span> <span
class="yiv1933934954hps">this problem</span> <span
class="yiv1933934954hps">somehow?</span></span><br>
<font size="-1"><br>
Albert<br>
</font> </div>
</div>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a moz-do-not-send="true"
ymailto="mailto:pgpool-general@pgpool.net"
href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a moz-do-not-send="true"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><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>
</body>
</html>