[pgpool-general: 2107] Re: pgpool-regclass No such file or directory

[Mistina Michal]

>> Hi Tatsuo.
>> 
>> I am experiencing following message in the pgpool.log file:
>> 
>> do_query: error message from backend: could not access file
>> "$libdir/pgpool-regclass": No such file or directory. Exit this session.
>> 
>>  
>> 
>> I know the Pgool cannot find regclass libraries or cannot access it. 
>> How can I determine where does Pgpool-II expect to have these libraries?

>pgpool-regclass is a user defined PostgreSQL function and "$libdir" is
controled by your PostgreSQL installtion, not by pgpool-II. To find out
where $libdir actually points to, you can use:

>pg_config --libdir

Thank you for reply Tatsuo.

I installed Pgpool-II from the package pgpool-II-3.3.0-1.pgdg.x86_64.rpm
downloaded from Pgpool download page.

I tried this:
[root at node01 ~]# su - postgres
-bash-4.1$ pg_config --libdir
/usr/pgsql-9.2/lib
-bash-4.1$ ll /usr/pgsql-9.2/lib | grep pgpool-
-rwxr-xr-x 1 root root   36686 Aug  5 04:17 pgpool-recovery.so
-rwxr-xr-x 1 root root   23214 Aug  5 04:17 pgpool-regclass.so

I also manually applied pgpool-recovery.sql and pgpool-regclass.sql as it is
required step in the installation guide:
su - postgres
cp /usr/pgsql-9.2/share/extension/pgpool-regclass.sql .
psql -f pgpool-regclass.sql template1
psql -f pgpool-regclass.sql <database>

If I try to access the <database> I applied sql script with pgAdmin I got
aforementioned error. I also got this error if I try to access it from
PostgreSQL shell.

Doesn't pgpool-regclass.sql create that user function which pgpool is
looking for? Or is it a file  /usr/pgsql-9.2/lib/pgpool-regclass? How can I
create the file and why it is not created by Pgpool-II rpm installation?

Best regards,
Michal Mistina

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3076 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130904/322b8f85/attachment.p7s>