> >> >> > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
