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

Tatsuo Ishii ishii at postgresql.org
Thu Dec 8 23:08:24 JST 2011


> 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?

Are you sure that your application queries are going through pgpool?
i.e. you should not directly connect to PostgreSQL standbys.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list