[Pgpool-general] problem with installation and testing

[Addison Pan]

Thanks and actually here's more information
   
  1. started postgres
  2. started pgpool
  3. check /tmp dir for nodes
  4. see 9999, 9998 started up, do not see 5433 and 5434
   
  based on the following pgpool.conf file:
   
listen_addresses = 'localhost'
port = 9999
  pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
child_max_connections = 0
  logdir = '/tmp'
  replication_mode = true
  replication_strict = true
  replication_timeout = 5000
  load_balance_mode = false
  replication_stop_on_mismatch = false
  replicate_select = false
  reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
  print_timestamp = true
  master_slave_mode = false
  connection_cache = true
  health_check_timeout = 20
  health_check_period = 0
  health_check_user = 'postgres'
  insert_lock = false
  ignore_leading_white_space = false
  log_statement = false
  log_connections = false
  log_hostname = false
  parallel_mode = false
  enable_query_cache = false
  pgpool2_hostname = 'localhost'
  system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = 'pgpool'
enable_pool_hba = false
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 1
backend_hostname1 = 'localhost'
backend_port1 = 5433
backend_weight1 = 1
backend_hostname2 = 'localhost'
backend_port2 = 5434
backend_weight2 = 1

  Any ideas?

Yoshiyuki Asaba <y-asaba at sraoss.co.jp> wrote:
  Hi,

From: Addison Pan 
Subject: [Pgpool-general] problem with installation and testing
Date: Fri, 21 Mar 2008 14:34:18 -0700 (PDT)

> does anyone have any ideas as to why 5433 and 5434 are not starting
> up? I also see via the pgpoolAdmin that those 2 nodes (via node
> status) are down

pgpool does not start up PostgreSQL process. You need to start up
postgres processes before starting up pgpool.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp
_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general


       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080323/a28c147e/attachment.html