[Pgpool-general] pgpool_walrecrunning not working from pgpool connection

[Tatsuo Ishii]

From: Daniel.Crespo at l-3com.com
Subject: RE: [Pgpool-general] pgpool_walrecrunning not working from pgpool connection
Date: Tue, 26 Oct 2010 19:15:00 -0400
Message-ID: <9E33F44949583B4597BDA2D0604256700B88D6CA at 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