The pcp_attach_node command is not available inside the pgpool container

[Wj-creat]

Name and Version

bitnami/pgpool

What architecture are you using?

None

What steps will reproduce the bug?

When there is a node in pgpool whose status is down and I use the command: pcp_attach_node -h localhost -U admin 2 in the pgpool container, it reports the error:

connection to host "localhost" failed with the error "Connection refused", 

why?

What is the expected behavior?

Node status changes to up

What do you see instead?

connection to host "localhost" failed with error "Connection refused"

[Wj-creat]

Detailed steps

$ docker exec -it pgpool bash
I have no name!@0c5a79dc9e6f:/$ pcp_attach_node -h localhost -U admin 2
Error: connection to host "localhost" failed with error "Connection refused"

[carrodher]

The issue may not be directly related to the Bitnami container image/Helm chart, but rather to how the application is being utilized, configured in your specific environment, or tied to a specific scenario that is not easy to reproduce on our side.

If you think that's not the case and are interested in contributing a solution, we welcome you to create a pull request. The Bitnami team is excited to review your submission and offer feedback. You can find the contributing guidelines here.

Your contribution will greatly benefit the community. Feel free to reach out if you have any questions or need assistance.

Suppose you have any questions about the application, customizing its content, or technology and infrastructure usage. In that case, we highly recommend that you refer to the forums and user guides provided by the project responsible for the application or technology.

With that said, we'll keep this ticket open until the stale bot automatically closes it, in case someone from the community contributes valuable insights.

[Wj-creat]

I opened the pgpool.conf file under the directory /opt/bitnami/pgpool/conf and turned on the following two commented out commands

#pcp_listen_addresses = 'localhost'                                  
#pcp_port = 9898

but why when I restart the container, i.e. docker restart pgpool, these two commands are commented out again? @carrodher

[andresbono]

Hi, the container entrypoint.sh generates the configuration file on each start of the container, as you can see in the logs:

INFO  ==> Generating pgpool.conf file...

If you want to add configuration customizations not directly supported by env-vars, please check this section in the readme: Configuration file.

[github-actions]

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

[github-actions]

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.