>> > 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 -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general