Re: Cannot connect to one specific postgres database on a server

<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:navy">I can telnet to the database and query the database…. The site that is using the
databaseis also running fine</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Not sure what postmaster is…. How can I check if <span class="GramE">its</span>
running?I did a <span class="SpellE">google</span> search for it, but not sure how to check it on my <span
class="SpellE">postgres</span>db server</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">I don’t get any errors using telnet … I can access the db every other way it
seems,just using <span class="SpellE">postgres</span></span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">If I restore/rebuild the db, will that cause the database to go down at all? I
willtry anything to get <span class="SpellE">pgadmin</span> working with the db… it makes my life SOOO much
easier!</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Thanks very much for taking the time to help me with this issue! Much
appreciated!</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy">Matt</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Tahoma"
size="2"><spanstyle="font-size:10.0pt;font-family:Tahoma">-----Original Message-----<br /><b><span
style="font-weight:bold">From:</span></b>Melvin Davidson [mailto:mdavidson@cctus.com] <br /><b><span
style="font-weight:bold">Sent:</span></b></span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">Monday,January 22, 2007</span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma"></span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">2:01PM</span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma"><br/><b><span style="font-weight:bold">To:</span></b> Matt Busby<br
/><b><spanstyle="font-weight:bold">Cc:</span></b> pgadmin-support@postgresql.org<br /><b><span
style="font-weight:bold">Subject:</span></b>RE: [pgadmin-support] Cannot connect to one specific postgres database on a
server</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial"
size="3"><spanstyle="font-size:12.0pt;font-family:Arial;color:blue">I cannot tell you what is specificially wrong, but
trythe following:</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font color="blue"
face="Arial"size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue">Can you telnet to that database and
query?</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial"
size="3"><spanstyle="font-size:12.0pt;font-family:Arial;color:blue">Is the postmaster running for that
database?</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial"
size="3"><spanstyle="font-size:12.0pt;font-family:Arial;color:blue">Do you get any errors returned when you try to
connectvia telnet? What are they?</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times New
Roman"size="3"><span style="font-size:12.0pt"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font
color="blue"face="Arial" size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue">Is it possible your
databaseis corrupted and you need to restore/rebuild?</span></font><p class="MsoNormal" style="margin-left:.5in"><font
face="TimesNew Roman" size="3"><span style="font-size:12.0pt"> </span></font><div align="center" class="MsoNormal"
style="margin-left:.5in;text-align:center"><fontface="Times New Roman" size="3"><span style="font-size:12.0pt"><hr
align="center"size="2" width="100%" /></span></font></div><p class="MsoNormal"
style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in"><b><font face="Tahoma" size="2"><span style="font-size:
10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]<b><span style="font-weight:bold">On Behalf Of </span></b>Matt Busby<br
/><b><spanstyle="font-weight:bold">Sent:</span></b> </span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">Monday,January 22, 2007</span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma"></span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">9:37AM</span></font><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma"><br/><b><span style="font-weight:bold">To:</span></b>
pgadmin-support@postgresql.org<br/><b><span style="font-weight:bold">Subject:</span></b> [pgadmin-support] Cannot
connectto one specific postgres database on a server</span></font><p class="MsoNormal" style="margin-left:.5in"><font
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial">Hello, </span></font><p class="MsoNormal"
style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">I am having
troubleconnecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin
display7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one.
Thisparticular database I am trying to connect to will just cause pgadmin to hang/crash </span></font><p
class="MsoNormal"style="margin-left:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial">I have been using pgadmin for over 2 years to
connectto this particular database that wont connect now. This just started happening a week ago and is frustrating me
sobad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on
theserver with no success… </span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"
style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">My server is
runninglinux, and I am using windows version of pgadmin…</span></font><p class="MsoNormal"
style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial"> </span></font><p
class="MsoNormal"style="margin-left:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">IWOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!</span></font><p
class="MsoNormal"style="margin-left:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font
face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial">Matt Busby</span></font></div>