[pgpool-general: 4759] Re: Cannot create pgpool_adm extension with pgpool 3.5.3

[Devrim Gündüz]

Hi,

On Mon, 2016-07-04 at 13:34 +0000, Avi Weinberg wrote:
> For some reason pgpool_adm.control cannot be found anywhere on the disk after
> pgpool 3.5.3 installation.  Is it missing from the installation or I'm doing
> something wrong
> 
> 
> [root at postgres_server1 ~]# su - postgres -c 'psql pgpool -c "CREATE EXTENSION
> pgpool_adm WITH SCHEMA pgpool ;"'
> ERROR:  could not open extension control file "/usr/pgsql-
> 9.5/share/extension/pgpool_adm.control": No such file or directory

Assuming that you are using PGDG RPMs, please install pgpool-II-95-extensions
RPM for that. Extensions are packaged separately:

# rpm -ql pgpool-II-95-extensions|grep pgpool_adm
/usr/pgsql-9.5/lib/pgpool_adm.so
/usr/pgsql-9.5/share/extension/pgpool_adm--1.0.sql
/usr/pgsql-9.5/share/extension/pgpool_adm.control

Regards,
-- 

Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: This is a digitally signed message part
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160705/3721869b/attachment.sig>