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

Tatsuo Ishii ishii at postgresql.org
Thu May 24 17:53:45 JST 2012


Are you sure that you installed pgpool_regclass in *all* the
databases?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> It is installed. Initially that was the only sql I installed but now I
> have built/installed all the packages/sql files from the install sql
> directory to see if I was missing anything.
> 
> I have pgpool-recovery.so, pgpool-regclass.so and
> pgpool-walrecrunning.so in my postgres lib directory and c language
> support is built into the databases.
> 
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at postgresql.org] 
> Sent: 23 May 2012 23:29
> To: Carman, Darren
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 490] Error on insert using pgpool and 2
> postgresql servers
> 
>> 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
> 
> Infoterra Ltd. Is part of the Astrium GEO-Information Services Division and a wholly owned subsidiary of Astrium, Europe's leading space systems and services specialist.
> 
> Disclaimer. The information contained in this e-mail and its attachments are confidential and intended only for the use of the named addressee(s). If you are not the intended addressee, please do not read, copy, use or disclose this message or its attachments. If you have received this message in error, please notify the sender immediately and delete or destroy all copies of this message and attachments in all media. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Infoterra Ltd and shall not form part of any binding agreement.
> 
> Infoterra Limited a company registered in England under number 2359955 and having its registered office at Atlas House, 41 Wembley Road, Leicester, LE3 1UT. VAT number GB 476 0468 27. 
> 
> P Before printing, think about the environment 
> 


More information about the pgpool-general mailing list