[pgpool-general: 4359] Re: having trouble installing online_recovery.

[Devrim GÜNDÜZ]

Hi,

On Thu, 2016-01-21 at 17:07 -0800, kiet.h.lieng wrote:
> I’m trying to get online recovery to work properly and running into
> issues when installing online_recovery feature for postgres database.
> 
> I’m following this http://www.pgpool.net/docs/latest/pgpool-en.html <
> http://www.pgpool.net/docs/latest/pgpool-en.html>.
> 
> The installation went fin with Make and Make install.
> 
> But I get the following errors when trying to create the function on
> one of the postgres servers.
> 
> --------------------
> psql -f pgpool-recovery.sql -U postgres 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:  could not access file
> "$libdir/pgpool-recovery": No such file or directory
> 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
> -------------------
> 
> 
> My question is: 
> 
> How do I solve the issue above?  How exactly do you set the $libdir
> variable?  I’m fairly new to postgres but it seems like $libdir is
> not a proper variable?  

$libdir automagically expands to the lib/ directory of your PostgreSQL
installation -- the actual place may vary depending on how you install
PostgreSQL.

Still, I think you should run

CREATE EXTENSION pgpool_recovery;

against the database that you want to install pgpool_recovery:

-HTH

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/20160125/cc5045d7/attachment.sig>