[pgpool-general: 9221] pgpool-ii configurations

[Long Nguyen]

Hi,

I am new to pgpool-ii and am setting it up. My env:
- postgresql 16 on ubuntu 22.04 on both primary and standby servers
- postgresql streaming replication is use
- install pgpool 4.5.4 on Primary server with streaming replication mode

I have followed online documentation and have some general questions.

1) Since pgpool accepts client connection and passes the same credential
supplied by client to postgresql server, do we have the same entries for
pgpool_hba.conf as in pg_hba.conf?

2) The documentation recommends a separate OS user to be used to run
pgpool. Do people do that or just use root? I created a 'pgpool' linux user
and used it, but encountered various issues with file  access permissions.

3) With the user we specify in the pcp.conf file, is it an OS user or
postgresql server user? Or is it neither? (The doco does not make this
clear.)

4) When is the user specified in the pcp.conf file referred to? Is this
when we issue PCP commands (e.g. pcp_attach_node). How about $HOME/.pcppass
file? If .pcppass is used then the pcp.conf file would not be referred to?

(I tried pcp_attach_node without supplying a password and got invalid
username/pwd. I had to use -W and manually entered the pwd).

Many thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20241015/7019fcdf/attachment.htm>