[pgpool-general: 9348] Re: pgpool connection

[Tatsuo Ishii]

> this my.cof
> 
> [root at localhost etc]# grep '^\ *[a-z]'
> /home/postgres/pgpool/etc/pgpool.conf | awk -F "#" '{print $1}'
> backend_clustering_mode = 'streaming_replication'
> listen_addresses = '*'
> port = 9999
> unix_socket_directories = '/tmp'
> backend_hostname0 = 'localhost'
> backend_port0 = 5432
> backend_weight0 = 1
> backend_data_directory0 = '/home/postgres/pgdata'
> backend_flag0 = 'ALLOW_TO_FAILOVER'
> backend_application_name0 = 'server0'
> enable_pool_hba = on
> pool_passwd = '*****'
> pid_file_name = '/var/run/pgpool/pgpool.pid'
> logdir = '/var/log/pgpool'
> load_balance_mode = on
> hostname0 = ''
> [root at localhost etc]#
> 
> btw , I want to know why the status shown by the systemctl status
> pgpool.service command is different from the status I see in the logs.
> Is this command usable, or should the status from the logs take
> precedence?

I don't know how you installed pgpool but If you installed from
Pgpool-II community RPM, pgpool.conf should be installed under
/etc/pgpool-II/pgpool.conf. But yours is at
/home/postgres/pgpool/etc/pgpool.conf. So I am confused.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp