[Pgpool-general] pgpool_walrecrunning not working from pgpool connection

[Tatsuo Ishii]

>> > 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