[pgpool-general: 491] Re: Error on insert using pgpool and 2 postgresql servers

[Tatsuo Ishii]

> I am getting an error when performing an insert using pgpool. I have 2
> servers with latest postgresql 9.1/postgis 1.5, 2nd server uses a direct
> copy of the data directory from the first server to ensure they are the
> same (i have tried dump/restore as well).
> 
>  
> 
> Version of pgpool is 3.1.3 and was installed using default configure (so
> no arguments). And is set in replication mode with load balancing on
> (config at the end of email).
> 
>  
> 
> All servers are running RedHat AS 6.1.
> 
>  
> 
> Selects work fine and when only using 1 server node in the config so do
> inserts. When using 2 server nodes I get an error inserting.

You seem to forgot to install pgpool_regclass().
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp