[Pgpool-general] pgpool_walrecrunning not working from pgpool connection

[Daniel.Crespo at l-3com.com]

> >> > Issuing:
> >> > psql -h 10.20.60.2 -U someuser -p 5432 -c "select
> >> > pgpool_walrecrunning()" db0
> >> > Returns:
> >> > pgpool_walrecrunning
> >> > ----------------------
> >> >  f
> >> > (1 row)
> 
> Thanks. What does this show?
> 
> psql -h 10.20.60.3 -U someuser -p 5432 -c "select
> pgpool_walrecrunning()" db0

Same error:
ERROR:  could not access file "$libdir/pgpool-walrecrunning": No such
file or directory

But good news, I found the error. I installed the functions into
"someuser" database, instead of the "postgres" database. I think pgpool
is using postgres as the user to run the pgpool_walrecrunning()
function, and therefore defaulting the database to "postgres" to run the
query. Now that I installed the pgpool-walrecrunning.sql into postgres
database, pgpool is now not complaining.

Thanks, Tatsuo.

-Daniel