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