<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: times new roman,new york,times,serif; font-size: 12pt; color: #000000'><font face="times new roman, new york, times, serif"><span style="font-size: 12pt;">Hi.</span></font><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">I still trying to make online recovery works with pgpool 3.4.1 and PGSQL 9.4. I have a fresh install of everything, but I'm stuck on XLOG function (used in second stage script).</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">When I try to execute, got this error:</div><div><div><font face="times new roman, new york, times, serif"><br></font></div><div><font face="times new roman, new york, times, serif">template1=# SELECT pgpool_switch_xlog('/var/lib/pgsql/9.4/data/archive_log');</font></div><div><font face="times new roman, new york, times, serif">ERROR: cannot find xlog functions</font></div></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">But this functions exists in template1 database!</div><div style="color: rgb(0, 0, 0); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><div style="font-size: 12pt;">template1=# SELECT p.proname</div><div style="font-size: 12pt;">template1-# FROM pg_catalog.pg_namespace n</div><div style="font-size: 12pt;">template1-# JOIN pg_catalog.pg_proc p</div><div style="font-size: 12pt;">template1-# ON p.pronamespace = n.oid</div><div style="font-size: 12pt;">template1-# WHERE n.nspname = 'public';</div><div style="font-size: 12pt;"> proname</div><div style="font-size: 12pt;">---------------------</div><div style="font-size: 12pt;"> pgpool_recovery</div><div style="font-size: 12pt;"> pgpool_recovery</div><div style="font-size: 12pt;"> pgpool_remote_start</div><div style="font-size: 12pt;"> pgpool_pgctl</div><div style="font-size: 12pt;"> pgpool_switch_xlog</div><div style="font-size: 12pt;">(5 rows)</div><div></div><div><br></div><div><br></div><div>I also have pgpool-recovery.so and pgpool-regclass.so in my pg lib dir, which is /usr/pgsql-9.4/lib</div><div><br></div><div>What am I doing wrong?</div><div><br></div><div>Tks!</div><div><br></div></div></div></body></html>