Can not always connect to postmaster. Sometimes get "Connection refused".
От | Hamedany, Allen |
---|---|
Тема | Can not always connect to postmaster. Sometimes get "Connection refused". |
Дата | |
Msg-id | 07FBB852E7D37D4F95879AF229258FF698ABC3@washington.revivio.com обсуждение исходный текст |
Список | pgsql-hackers |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">We’re running postgres7.3 on RedHat7.3. The Postgres at boot time starts up from a java (1.2) class thatruns the following commands in order:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/usr/local/pgsql/bin/pg_ctl -w start -D /var/lib/pgsql -l /var/log/pgsqld.log -o –i</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/usr/local/pgsql/bin/createdb management</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial">.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">As you can tell the postmaster starts up with “-i” option here. </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">In pg_hba.conf we have:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">local all all trust</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">host all all 127.0.0.1 255.255.255.255 trust</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">host all all 192.168.0.0 255.255.0.0 trust</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">The host IP address is 192.168.55.5 which is in the right subnet.</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">In postgresql.conf: </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"># Connection Parameters</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">tcpip_socket = true</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#ssl = false</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">max_connections = 64</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#superuser_reserved_connections = 2</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#port = 5432 </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#hostname_lookup = false</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#show_source_port = false</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#unix_socket_directory = ''</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#unix_socket_group = ''</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">#unix_socket_permissions = 0777 # octal</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">tcpip_socket = true</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Sometimes, after Postgres starts up, when the database clients try to access the db from the localhost,we get the following error:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><span style="font-size:10.0pt">com.solarmetric.kodo.Runtime- com.solarmetric.kodo.runtime.FatalDataStoreException: Connection refused.Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. </span></font></span><pclass="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><span style="font-size:10.0pt"> </span></font></span><pclass="MsoNormal" style="margin-left:.5in;text-indent:-.25in"><span class="f40"><fontface="Times New Roman" size="2"><span style="font-size:10.0pt">a)<font face="Times New Roman" size="1"><spanstyle="font:7.0pt "Times New Roman""> </span></font></span></font></span><span class="f40"><font size="2"><spanstyle="font-size:10.0pt">Any ideas what’s causing postmaster NOT to accept connections some of the time?</span></font></span><pclass="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><span style="font-size:10.0pt"> </span></font></span><pclass="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><spanstyle="font-size:10.0pt">This problem almost always goes away upon rebooting the machine.</span></font></span><pclass="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><span style="font-size:10.0pt"> </span></font></span><pclass="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><spanstyle="font-size:10.0pt">Any help is much appreciated.</span></font></span><p class="MsoNormal"><span class="f40"><fontface="Times New Roman" size="2"><span style="font-size:10.0pt"> </span></font></span><p class="MsoNormal"><spanclass="f40"><font face="Times New Roman" size="2"><span style="font-size:10.0pt">Thanks,</span></font></span><pclass="MsoNormal"><span class="f40"><font face="Times New Roman" size="2"><spanstyle="font-size:10.0pt">-Allen</span></font></span><font size="2"><span style="font-size:10.0pt"><br /><br/></span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font></div> **************************************************************************************<br/>This email message and any filestransmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed.If you have received this email message in error, please notify the sender immediately by telephone or email anddestroy the original message without making a copy. Thank you.<br />**************************************************************************************<br/><br />
В списке pgsql-hackers по дате отправления: