sorry again needed to rm /tmp/pgpool_status...
> Using 2.3.3 > > I suspect the log line : > "new_connection: skipping slot 1 because backend_status = 3" > > when asking pgpool to log all statements, and backends receiving > them, I can see that statement are only sent to backend 0 > > I can see that also in postgres logs, > backend 1 doesn't even show connection attempts > > LOG: > > 2010-05-11 06:52:12 DEBUG: pid 4348: I am 4348 > 2010-05-11 06:52:12 DEBUG: pid 4349: I am 4349 > 2010-05-11 06:52:12 DEBUG: pid 4350: I am 4350 > 2010-05-11 06:52:12 DEBUG: pid 4351: I am 4351 > 2010-05-11 06:52:12 DEBUG: pid 4352: I am 4352 > 2010-05-11 06:52:12 DEBUG: pid 4353: I am 4353 > 2010-05-11 06:52:12 DEBUG: pid 4354: I am 4354 > 2010-05-11 06:52:12 DEBUG: pid 4355: I am 4355 > 2010-05-11 06:52:12 LOG: pid 4281: pgpool-II successfully started. > version 2.3.2.2 (tomiteboshi) > 2010-05-11 06:52:12 DEBUG: pid 4356: I am PCP 4356 > > 2010-05-11 06:52:26 DEBUG: pid 4355: I am 4355 accept fd 5 > 2010-05-11 06:52:26 DEBUG: pid 4355: Protocol Major: 3 Minor: 0 database: > postgres user: postgres > 2010-05-11 06:52:26 DEBUG: pid 4355: new_connection: connecting 0 backend > 2010-05-11 06:52:26 DEBUG: pid 4355: new_connection: connecting 1 backend > 2010-05-11 06:52:26 DEBUG: pid 4355: new_connection: skipping slot 1 > because backend_status = 3 > 2010-05-11 06:52:26 DEBUG: pid 4355: pool_ssl: SSL requested but SSL > support is not available > 2010-05-11 06:52:26 LOG: pid 4355: pool_do_auth: maybe protocol version > mismatch (current version 3) > 2010-05-11 06:52:26 DEBUG: pid 4355: pool_read_string: read all from > pending data. po:1 len:93 > > CONF: > > # Host name or IP address to listen on: '*' for all, '' for no TCP/IP # > connections > listen_addresses = '*' > > # Port number for pgpool > port = 5432 > > # Port number for pgpool communication manager > pcp_port = 9898 > > # Unix domain socket path. (The Debian package defaults to > # /var/run/postgresql.) > socket_dir = '/tmp' > > # Unix domain socket path for pgpool communication manager. > # (Debian package defaults to /var/run/postgresql) > pcp_socket_dir = '/tmp' > > > ...default from sample.. > > # Replication mode > replication_mode = true > > # Load balancing mode, i.e., all SELECTs are load balanced. > # This is ignored if replication_mode is false. > load_balance_mode = false > > # if there's a data mismatch between master and secondary > # start degeneration to stop replication mode > replication_stop_on_mismatch = false > > # If true, replicate SELECT statement when load balancing is disabled. # > If false, it is only sent to the master node. > replicate_select = false > > ..default.. > > # system DB info > 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_hostname, backend_port, backend_weight > # here are examples > backend_hostname0 = 'localhost' > backend_port0 = 9999 > backend_weight0 = 1 > backend_data_directory0 = '/var/lib/pgsql/data' > backend_hostname1 = 'the.other.server.ip' > backend_port1 = 5432 > backend_weight1 = 1 > backend_data_directory1 = '/var/lib/pgsql/data' > > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > -- Asaf Ohaion Lingnu Open Source Consulting Ltd 09-7655871 (204), 0547-920828 http://www.lingnu.com _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
