From: [email protected] Subject: RE: [Pgpool-general] pgpool_walrecrunning not working from pgpool connection Date: Tue, 26 Oct 2010 19:15:00 -0400 Message-ID: <9e33f44949583b4597bda2d0604256700b88d...@fls-exchange.corp.sds.l-3com.com>
>> >> > 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. To make sure can you show me your pgpool.conf? -- 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 [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
