I'm new to pgpool2 as well, but don't you want to be replicating the inserts and updates? because your slave would not be getting the new data otherwise.
On 03/30/2010 12:05 AM, Gaetan Allart wrote: > Hi everybody, > > I'm a new user of PgPool-II and I'm experiencing a strange issue with it. > I have two PostgreSQL servers acting as master/slave. All INSERT/UPDATE > queries go to master and SELECT queries are load-balanced over master and > slave. > > This configuration works pretty fine, at least for minutes... > > Upon startup, pgpool correctly load-balances queries over my two servers. But > within minutes, queries sent to slave are decreasing... decreasing... > decreasing... > Within 30 minutes, my master gets all queries and becomes sick... > > ncp_node_info tells me that status of both servers is all right (status = 2). > Even more strange, if I ncp_node_detach and re-attache my slave server, it > then gets queries back. And once again, within minutes, load falls down > without any particular reason. > > Here is my config_file : > > listen_addresses = '0.0.0.0' > port = 5433 > pcp_port = 9898 > socket_dir = '/tmp' > pcp_socket_dir = '/tmp' > backend_socket_dir = '/tmp' > pcp_timeout = 10 > num_init_children = 64 > max_pool = 4 > child_life_time = 0 > connection_life_time = 0 > child_max_connections = 0 > client_idle_limit = 0 > authentication_timeout = 10 > logdir = '/var/run' > pid_file_name = '/var/run/pgpool/pgpool.pid' > replication_mode = false > load_balance_mode = true > replication_stop_on_mismatch = false > replicate_select = false > reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT' > print_timestamp = true > master_slave_mode = true > connection_cache = true > health_check_timeout = 20 > health_check_period = 0 > health_check_user = 'nobody' > failover_command = '' > failback_command = '' > insert_lock = true > ignore_leading_white_space = true > log_statement = false > log_connections = false > log_hostname = false > parallel_mode = false > enable_query_cache = false > pgpool2_hostname = '' > backend_hostname0 = 'localhost' > backend_port0 = 5432 > backend_weight0 = 0.4 > backend_hostname1 = 'Ip.Of.My.Server' > backend_port1 = 5432 > backend_weight1 = 0.6 > enable_pool_hba = true > recovery_user = 'nobody' > recovery_password = '' > recovery_1st_stage_command = '' > recovery_2nd_stage_command = '' > recovery_timeout = 90 > client_idle_limit_in_recovery = 0 > > My pgpool version : > > pgpool-II version 2.3.1 (tomiteboshi) > > > Any idea where I should look at? > > > Best regards, > Gaëtan > > > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
