> >> > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
