> >> > I'm using Postgresql 9.0 and the latest pgpool from CVS Head from > >> > Thursday October 21st, for streaming replication. > >> > > >> > > >> > > >> > When I start pgpool-II, and see the postgresql log file, its > output > >> > states that pgpool_walrecrunning() can not access > >> > '$libdir/pgpool_walrecrunning': No such file or directory. > >> > > >> > > >> > > >> > pgpool_walrecrunning.so is actually there. What is more important, > >> when > >> > I connect directly to postgresql it returns properly. But if I > >> connect > >> > using pgpool's port (9999 by default), the above error is shown. > >> > > >> > > >> > > >> > I did enter the sql directory of pgpool source, and compiled and > >> > installed each of the components, including pgpool_walrecrunning. > >> > > >> > > >> > > >> > Is there something I'm missing? > >> > >> Are you sure that you installed pgpool_walrecrunning on each DB > node? > > > > Yes. I did. Here is what I experience: > > > > ********* Directly to postgres ************* > > -bash-3.2$ psql -U someuser -p 5432 db0 > > psql (9.0.1) > > Type "help" for help. > > > > db0=# select pgpool_walrecrunning(); > > pgpool_walrecrunning > > ---------------------- > > f > > (1 row) > > > > db0=# \q > > > > ************* Through pgpool *************** > > -bash-3.2$ psql -U someuser -p 9999 db0 > > psql (9.0.1) > > Type "help" for help. > > > > db0=# select pgpool_walrecrunning(); > > ERROR: could not access file "$libdir/pgpool-walrecrunning": No such > > file or directory > > db0=# \q > > What are your backend_hostnameN in pgpool.conf? > For example, if your backend_hostname0 is "somehost", you want to try: > > psql -h somehost -U someuser -p 5432 -c "select pgpool_walrecrunning()" > db0
backend_hostname0=10.20.60.2 Issuing: psql -h 10.20.60.2 -U someuser -p 5432 -c "select pgpool_walrecrunning()" db0 Returns: pgpool_walrecrunning ---------------------- f (1 row) For your information: In my case, I have pgpool on the same host. Thanks, -Daniel _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
