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

[kiet.h.lieng]

I’m running on Centos 7.2.  Postgres 9.2.  I’ve tried this on a number of machines, nothing seems to work.

> On Jan 21, 2016, at 5:07 PM, kiet.h.lieng <kiet.h.lieng at gmail.com> wrote:
> 
> Hi all.  
> 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?  
> 
> 
> There were 2 particular instances on the mailing list that somewhat mentions how they solved this:
> 
> >1. http://www.sraoss.jp/pipermail/pgpool-general/2012-June/000631.html <http://www.sraoss.jp/pipermail/pgpool-general/2012-June/000631.html> -     "We were able to solve our problem by placing the pgpool-regclass.so where the postgresql backend was expecting it.”
> 
> I have no idea where posthgres is expecting it to be.  I copied the .so files to the postgres directories, restarted.  It didn’t seem to work.
> 
> > 2. http://www.sraoss.jp/pipermail/pgpool-general/2012-December/001255.html <http://www.sraoss.jp/pipermail/pgpool-general/2012-December/001255.html>
> 
> This one says to install it into postgres and restart.  (possible future routes but I’m hoping I don’t have to do this).
> 
> 
> Thanks for your time and patience.
> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160125/b712d579/attachment.html>