[pgpool-general: 9352] Re: pgpool connection

[Tatsuo Ishii]

Please Cc: to pgpool-general at pgpool.net.

Ok, for some reasons you have 2 pgpools. One is self compiled, the
other is installed from RPM. Anyway, it's apparent that you started
one of pgpools with pgpool.conf other than
/home/postgres/pgpool/etc/pgpool.conf because if you use
/home/postgres/pgpool/etc/pgpool.conf, socket directroy must be /tmp
but the log shows that the socket directory is /var/run/postgresql/.
I recommend you to recheck the start up procedure of pgpool.

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

> umm.. this location matter? Because my steps are  After extracting, run
> ./configure, make, and make install, then use yum rpm.  When running
> ./configure, my syntax is ./configure --prefix=/home/postgres/pgpool.
> The steps I see are to execute it directly, and the location will appear
> under /usr/local/etc/.
> 
> 
> Tatsuo Ishii <ishii at postgresql.org> 於 2025年2月11日 週二 下午7:51寫道：
> 
>> > 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
>>
>>