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

[Albert]

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 <mailto: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/904ff344/attachment.html>