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

[Sandeep Thakkar]

According to the docs (http://pgpool.projects.postgresql.org/NEWS.txt),  

"In master/slave mode, SELECTs to temporary table executes only on master/primary"
 


________________________________
 From: Albert <forall at stalowka.info>
To: Sandeep Thakkar <sandeeptt at yahoo.com> 
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Sent: Thursday, December 8, 2011 4:13 PM
Subject: Re: [pgpool-general: 60] Pgpool + streaming replication
 

On 08.12.2011 11:37, Sandeep Thakkar wrote: 
Does "sess" 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?
>
>
>
>________________________________
> From: Albert <forall at stalowka.info>
>To: pgpool-general at pgpool.net 
>Sent: Thursday, December 8, 2011 3:29 PM
>Subject: [pgpool-general: 60] Pgpool + streaming replication
> 
>
>Hello,
>
>I testing now pgpool with streaming replication and I
                  have problem with temporary tables in my database.
>When my application try connect to standby server and
                  run query select I get error message e.g
>CETERROR:  relation "sess" does not exist 
>
>Do PGPool can solve this problem somehow?
>
>Albert
> 
>_______________________________________________
>pgpool-general mailing list
>pgpool-general at pgpool.net
>http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
'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 ?

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