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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Disaster!
Следующее
От: elein
Дата:
Сообщение: Re: Named arguments in function calls