[pgpool-general: 1891] Re: Pgpool 3.2.4 streaming replication: "pgpool_regclass(cstring)" does not exist

Tatsuo Ishii ishii at postgresql.org
Sat Jul 13 11:15:52 JST 2013


> Hi!
> I have Pgpool 3.2.4 installed with 2 postgresql 9.2.4 backends with streaming replication enabled.
> 
> I can see the following message in pgpool.log :
> 
> Jul 12 20:59:52 lb-node1 pgpool[3673]: do_query: error message from backend function "pgpool_regclass(cstring)" does not exist
> 
> Similar message in master backend log:
> 
> 2013-07-12 20:59:52 UTC ERROR:  function "pgpool_regclass(cstring)" does not exist
> 
> However I can see that  pgpool_regclass is installed on both backends:
> 
> Backend1:
> 
> template1=# \df
>                                 List of functions
>  Schema |         Name         | Result data type | Argument data types |  Type
> --------+----------------------+------------------+---------------------+--------
>  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
> (5 rows)
> 
> 
> Backend2:
> 
> template1=# \df
>                                 List of functions
>  Schema |         Name         | Result data type | Argument data types |  Type
> --------+----------------------+------------------+---------------------+--------
>  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
> (5 rows)
> 
> 
> Could you please tell me what this error messages mean? 

Are you sure that you installed pgpool_regclass in all databases you
want to connect to?
--
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