<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hi all. </div><div class="">I’m trying to get online recovery to work properly and running into issues when installing online_recovery feature for postgres database.</div><div class=""><br class=""></div><div class="">I’m following this <a href="http://www.pgpool.net/docs/latest/pgpool-en.html" class="">http://www.pgpool.net/docs/latest/pgpool-en.html</a>.</div><div class=""><br class=""></div><div class="">The installation went fin with Make and Make install.</div><div class=""><br class=""></div><div class="">But I get the following errors when trying to create the function on one of the postgres servers.</div><div class=""><br class=""></div><div class="">--------------------</div><div class=""><div class="">psql -f pgpool-recovery.sql -U postgres template1</div><div class="">psql:pgpool-recovery.sql:4: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory</div><div class="">psql:pgpool-recovery.sql:9: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory</div><div class="">psql:pgpool-recovery.sql:14: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory</div><div class="">psql:pgpool-recovery.sql:19: ERROR: could not access file "$libdir/pgpool-recovery": No such file or directory</div></div><div class="">-------------------</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">My question is: </div><div class=""><br class=""></div><div class="">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? </div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">There were 2 particular instances on the mailing list that somewhat mentions how they solved this:</div><div class=""><br class=""></div><div class="">>1. <a href="http://www.sraoss.jp/pipermail/pgpool-general/2012-June/000631.html" class="">http://www.sraoss.jp/pipermail/pgpool-general/2012-June/000631.html</a> - <span style="widows: 1;" class=""> "</span><span style="widows: 1;" class="">We were able to solve our problem by placing the pgpool-regclass.so where </span><span style="widows: 1;" class="">the postgresql backend was expecting it.</span><span style="widows: 1;" class="">”</span></div><div class=""><span style="widows: 1;" class=""><br class=""></span></div><div class=""><span style="widows: 1;" class="">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.</span></div><div class=""><span style="widows: 1;" class=""><br class=""></span>> 2. <a href="http://www.sraoss.jp/pipermail/pgpool-general/2012-December/001255.html" class="">http://www.sraoss.jp/pipermail/pgpool-general/2012-December/001255.html</a></div><div class=""><br class=""></div><div class="">This one says to install it into postgres and restart. (possible future routes but I’m hoping I don’t have to do this).</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Thanks for your time and patience.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></body></html>