[pgpool-general: 2107] Re: pgpool-regclass No such file or directory
Michal.Mistina at virte.sk
Wed Sep 4 16:17:17 JST 2013
>> 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:
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
-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
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?
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 3076 bytes
Desc: not available
More information about the pgpool-general