[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.
> 
> To make sure can you show me your pgpool.conf?

listen_addresses = '*'
port = 9999
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 100
max_pool = 1
child_life_time = 0
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/opt/pgpool/log/'
pid_file_name = '/opt/pgpool/pgpool.pid'
replication_mode = false
load_balance_mode = true
replication_stop_on_mismatch = false
failover_if_affected_tuples_mismatch = false
replicate_select = false
reset_query_list = 'ABORT; DISCARD ALL'
white_function_list = ''
black_function_list = 'nextval,setval,addnewteam'
print_timestamp = true
master_slave_mode = true
master_slave_sub_mode = 'stream'
delay_threshold = 10000000
log_standby_delay = 'if_over_threshold'
connection_cache = true
health_check_timeout = 30
health_check_period = 10
health_check_user = 'postgres'
failover_command = '/opt/pgpool/bin/trigger_failover_command %m'
failback_command = 'touch FAILBACK_OCCURRED'
fail_over_on_backend_error = true
insert_lock = false
ignore_leading_white_space = true
log_statement = false
log_per_node_statement = false
log_connections = false
log_hostname = false
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = ''
system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''
backend_hostname0 = '10.20.60.2'
backend_port0 = 5432
backend_weight0 = 0
backend_data_directory0 = '/var/lib/pgsql/9.0/data'
backend_hostname1 = '10.20.60.3'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/9.0/data'
enable_pool_hba = false
recovery_user = 'nobody'
recovery_password = ''
recovery_1st_stage_command = ''
recovery_2nd_stage_command = ''
recovery_timeout = 90
client_idle_limit_in_recovery = 0
lobj_lock_table = ''
ssl = false
debug_level = 0

Thanks,
-Daniel