<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Just to mention, we are using pgpool 3.2.3, postgres 9.1, pgpooladmin 3.2.0 and the server is Centos 6.2.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net] <b>On Behalf Of </b>Stelios Limnaios<br><b>Sent:</b> 22 May 2013 16:28<br><b>To:</b> pgpool-general@pgpool.net<br><b>Subject:</b> [pgpool-general: 1767] Pgpool with backends on the same box problem<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I would like to ask for some help on a strange issue we have.<o:p></o:p></p><p class=MsoNormal>We have successfully installed pgpool in the past, on one of our servers with 2 back-ends each one on a separate server.<o:p></o:p></p><p class=MsoNormal>Everything works ok on this cluster.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Now, we’re trying to install a similar cluster (pgpool and 2 backends) on a separate server for testing purposes.<o:p></o:p></p><p class=MsoNormal>We want to install everything on one box.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The problem we have is that pgpooladmin shows the nodes as down although the databases are running and the ports are open to the network. Also, when we start pgpool from the pgpooladmin, we get e1002 - pcp_node_count command error occurred.<o:p></o:p></p><p class=MsoNormal>The strange is that if we use a backend that is located on a different server pgpooladmin shows fine its status.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>What are we missing? Is it something related to permissions? Any direction will be much appreciated.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you in advance,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,<o:p></o:p></p><p class=MsoNormal>Stelios Limnaios<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>