[Pgpool-general] pgpool_walrecrunning not working from pgpool connection

[Tatsuo Ishii]

>> >> > 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

You need to install pgpool_walrecrunning() into 10.20.60.3 PostgreSQL
as well.

> 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