[Pgpool-general] pgpool_walrecrunning not working from pgpool connection

[Daniel.Crespo at 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.

Thanks,
-Daniel