[Pgpool-general] psql commands cause fail over

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jan 18 23:02:46 UTC 2011


>> If you still have an error in spite of disabling replicate_select,
>> please let me know details (pgpool.conf, pgpool-II version).
> 
> I think the problem is with the function with insert/update sqls in
> it, if the replicate_select is off and I use 'select func_xxx()', then
> it will only execute on the primary server, in this case, the
> insert/update won't be performed on the secondary server and will
> cause failover later on.
> 
> Any suggestion/solution on how to handle this situation ?

I'm confused. Weren't you talking about \d command?
--
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