[pgpool-general: 4161] Issues with pgpool libraries

[Vaidyanathaswamy, Sai (NBCUniversal)]

Hi,

I have issues for creating regclass and also pgpool-recovery.

Pgpool is installed only on our  master server.  I am trying the create a regclass functions used internally by pgpool-II, I don't see any proper solutions in your community.

Can you please show us some light on this issue.


$ cd pgpool-II-x.x.x/sql/pgpool-regclass
$ make
$ make install
After this:
$ psql -f pgpool-regclass.sql template1
or
$ psql template1

=# CREATE EXTENSION pgpool_regclass;
Executing pgpool-regclass.sql or CREATE EXTENSION should be performed on every databases accessed with pgpool-II. You do not need to do this for a database created after the execution of "psql -f pgpool-regclass.sql template1" or CREATE EXTENSION, as this template database will be cloned to create new databases.



bash-4.1$ psql -f pgpool_regclass--1.0.sql template1
Use "CREATE EXTENSION pgpool_regclass" to load this file.
bash-4.1$ psql
psql (8.4.20, server 9.4.4)
WARNING: psql version 8.4, server version 9.4.
         Some psql features might not work.
Type "help" for help.

postgres=# \q
bash-4.1$ psql -template1
psql: invalid option -- 'm'
Try "psql --help" for more information.
bash-4.1$ psql -d template1
psql (8.4.20, server 9.4.4)
WARNING: psql version 8.4, server version 9.4.
         Some psql features might not work.
Type "help" for help.

template1=# CREATE EXTENSION pgpool_regclass;
ERROR:  could not access file "$libdir/pgpool-regclass": No such file or directory
template1=# pwd
template1-#



I have same issue for installating   pgpool_recovery same errors


mnt/gpfs/stage/disk/postgres/pgpool/pgpool-II-3.3.3/sql
[sas at aoaapld00103 sql]$ cd pgpool-recovery
[sas at aoaapld00103 pgpool-recovery]$ ls -lrt
total 64
-rwxr-xr-x. 1 postgres postgres   136 Mar 24  2014 uninstall_pgpool-recovery.sql
-rwxr-xr-x. 1 postgres postgres   527 Mar 24  2014 pgpool-recovery.sql.in
-rwxr-xr-x. 1 postgres postgres   160 Mar 24  2014 pgpool_recovery.control
-rwxr-xr-x. 1 postgres postgres  8149 Mar 24  2014 pgpool-recovery.c
-rwxr-xr-x. 1 postgres postgres   791 Mar 24  2014 pgpool_recovery--1.0.sql
-rwxr-xr-x. 1 postgres postgres   680 Mar 24  2014 Makefile
-rwxr-xr-x. 1 postgres postgres 35814 Oct 29 16:01 pgpool-recovery.so
-rwxr-xr-x. 1 postgres postgres   594 Oct 29 16:15 pgpool-recovery.sql
[sas at aoaapld00103 pgpool-recovery]$ pwd
/mnt/gpfs/stage/disk/postgres/pgpool/pgpool-II-3.3.3/sql/pgpool-recovery
[sas at aoaapld00103 pgpool-recovery]$ sudo su postgres
[sudo] password for sas:
bash-4.1$ psql -f pgpool-recovery.sql template1
psql:pgpool-recovery.sql:4: ERROR:  could not access file "$libdir/pgpool-recovery": No such file or directory
psql:pgpool-recovery.sql:9: ERROR:  syntax error at or near "public"
LINE 3: AS '$libdir/pgpool-recovery', public.'pgpool_remote_start'
                                      ^
psql:pgpool-recovery.sql:14: ERROR:  could not access file "$libdir/pgpool-recovery": No such file or directory
psql:pgpool-recovery.sql:19: ERROR:  could not access file "$libdir/pgpool-recovery": No such file or directory
bash-4.1$



All the libraries are there under   /usr/pgsql-9.4/lib
[sas at aoaapld00103 lib

Your help is much appreciated.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20151102/d12ad245/attachment.htm>