Pgpool pool_nodes output

SOLVED
Highlighted
Level 2 Adventurer

Pgpool pool_nodes output

While executing show pool_nodes the output shows both the servers as standby whereas one is primary and one is standby. What is that I am missing? 1 of my function uses this and failing.

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: Pgpool pool_nodes output

Hi  esamuel,

 

Verify sr_check_user and sr_check_password are set correctly. Here you can assign a username and password which will have replication user permissions.

 

If these two parameters are not set properly then pool_nodes shows both as standby. This is because pgpool executes some query to find out which one is in recovery and which one is not. To execute these query pgool uses this username and password.

 

Also, whenever you start the pgpool service include -D option, this clears the earlier status of pool_nodes if they were failed and shows current status.

View solution in original post

5 REPLIES 5
Highlighted
EDB Team Member

Re: Pgpool pool_nodes output

Hi esamuel,

 

It will be helpful to analyze the issue if you please share the Pgpool configuration file and show pool_nodes output.

 

Awaiting reply.

Regards,
Dhananjay
Highlighted
Level 2 Adventurer

Re: Pgpool pool_nodes output

can you tell me where is the location of conf file ?
Highlighted
EDB Team Member

Re: Pgpool pool_nodes output

Hi esamuel,

 

Pgpool.conf configuration file is located at /usr/local/etc with default installation from source code. (probably you need root privilege for this).

 

Hope this helps.

Regards,
Dhananjay
Highlighted
EDB Team Member

Re: Pgpool pool_nodes output

Hi  esamuel,

 

Verify sr_check_user and sr_check_password are set correctly. Here you can assign a username and password which will have replication user permissions.

 

If these two parameters are not set properly then pool_nodes shows both as standby. This is because pgpool executes some query to find out which one is in recovery and which one is not. To execute these query pgool uses this username and password.

 

Also, whenever you start the pgpool service include -D option, this clears the earlier status of pool_nodes if they were failed and shows current status.

View solution in original post

Highlighted
Level 2 Adventurer

Re: Pgpool pool_nodes output

Thank you. Let me try that.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks