title: How do I get pcp to automatically attach nodes to postgres pgpool?
body: <p>I'm using postgres 9.4.9, pgpool 3.5.4 on centos 6.8.</p>
  
  <p>I'm having a major hard time getting pgpool to automatically detect when nodes are up (it often detects the first node but rarely detects the secondary) but if I use pcp_attach_node to tell it what nodes are up, then everything is hunky dory.</p>
  
  <p>So I figured until I could properly sort the issue out, I would write a little script to check the status of the nodes and attach them as appropriate, but I'm having trouble with the password prompt. According to the documentation, I should be able to issue commands like</p>
  
  <pre><code>pcp_attach_node 10 localhost 9898 pgpool mypass 1
  </code></pre>
  
  <p>but that just complains</p>
  
  <p>pcp_attach_node: Warning: extra command-line argument "localhost" ignored
  pcp_attach_node: Warning: extra command-line argument "9898" ignored
  pcp_attach_node: Warning: extra command-line argument "pgpool" ignored
  pcp_attach_node: Warning: extra command-line argument "mypass" ignored
  pcp_attach_node: Warning: extra command-line argument "1" ignored</p>
  
  <p>it'll only work when I use parameters like </p>
  
  <pre><code>pcp_attach_node -U pgpool -h localhost -p 9898 -n 1 
  </code></pre>
  
  <p>and there's no parameter for the password, I have to manually enter it at the prompt.</p>
  
  <p>Any suggestions for sorting this other than using Expect?</p>