[pgpool-general: 494] Re: Error on insert using pgpool and 2 postgresql servers
darren.carman at infoterra-global.com
Thu May 24 18:07:07 JST 2012
Yes, I installed it to my database and to template1 on both servers.
Is this function only used for inserts?
Running \df on both servers as postgres user shows:
public | pgpool_recovery | boolean | text, text, text | normal
public | pgpool_regclass | oid | cstring | normal
public | pgpool_remote_start | boolean | text, text | normal
public | pgpool_switch_xlog | text | text | normal
public | pgpool_walrecrunning | boolean | | normal
The connections used for inserts were as another user, but as the above
are public I assume this isn't a problem (dblink functions are public
From: Tatsuo Ishii [mailto:ishii at postgresql.org]
Sent: 24 May 2012 09:54
To: Carman, Darren
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 490] Error on insert using pgpool and 2
Are you sure that you installed pgpool_regclass in *all* the databases?
SRA OSS, Inc. Japan
> 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
>> 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
>> 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