[pgpool-general: 1864] PgPool Function Errors (Installation Issue?)

[Andrew Bruce]

Hi all,

I have a PgPool installation (3.2.4) that is, on the whole, working very
well. However, I have noticed some interesting entries in the log files:

--- Begin Log Entry ---

BST ERROR:  function "pgpool_regclass(cstring)" does not exist
BST STATEMENT:  SELECT count(*) FROM pg_catalog.pg_proc AS p WHERE
p.proname = 'pgpool_regclass' AND has_function_privilege('postgres',
'pgpool_regclass(cstring)', 'execute')

--- End Log Entry ---

I had installed the system correctly (as far as I can tell - i.e. all
the PgPool functions were compiled and installed without any issues),
and I executed the SQL queries against the 'postgres' and 'template1'
databases - indeed, querying for the installed functions (hopefully, the
text all lines up!):

postgres=# SELECT proname, prosrc
                        FROM pg_catalog.pg_namespace n
                        JOIN pg_catalog.pg_proc p
                       ON pronamespace = n.oid
                       WHERE nspname = 'public';
       proname      |                                 prosrc
-------------------+----------------------------------------------------
--------------------
 last_day		|
			:   SELECT (date_trunc('MONTH', $1) + INTERVAL
'1 MONTH - 1 day')::date;
			:
 pgpool_regclass	| pgpool_regclass
 pgpool_recovery	| pgpool_recovery
 pgpool_remote_start	| pgpool_remote_start
 pgpool_switch_xlog	| pgpool_switch_xlog
 pgpool_walrecrunning	| pgpool_walrecrunning
(6 rows)

I have also used pg_dumpall from another system, and imported another
set of databases into the PgPool system, and I have started to see the
error I quoted above when I run simple queries on the additional
databases...

My questions:

Should the pgpool functions be installed against all databases within
the cluster (i.e. 'postgres', 'template1', and any other subsequent
database)?

Is this is significant problem?

Is this a known problem?

I can make the errors go away by adding the functions to the offending
database...

Thanks in advance for any insights anyone can give.

Kind regards,

Andy Bruce