Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

From: Anne Marie Harm <amharm(at)earthlink(dot)net>
To: Malik Rumi <malik(dot)a(dot)rumi(at)gmail(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Date: 2018-11-24 17:03:53
Message-ID: 514259035.1790.1543079033600@wamui-koala.atl.sa.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style=""><style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><font face="georgia, serif"><span style="font-size: 16px;">[I removed pgsql-hackers(at)lists(dot)postgresql(dot)org address from this reply since it looked like agreement this does not belong there. However one said this belongs on the pgadmin-support(at)lists(dot)postgresql(dot)org list, and another said it belongs on pgsql-admin(at)lists(dot) postgresql.org, so I kept both here; I hope okay.]</span></font><div><font face="georgia, serif"><span style="font-size: 16px;"><br></span></font></div><div><font face="georgia, serif"><span style="font-size: 16px;">Hello,&nbsp;</span></font><br><br><span style="font-family: georgia, serif; font-size: 16px; color: rgb(0, 0, 0);">I appreciate all the response. Here are my replies, in</span><font color="#c10066" style="font-family: georgia, serif; font-size: 16px;"><font color="#000000">&nbsp;</font><b style="">purple</b><font color="#000000" style="color: rgb(0, 0, 0);">&nbsp;</font></font><span style="font-family: georgia, serif; font-size: 16px; color: rgb(0, 0, 0);">below:</span><blockquote style="font-family: arial, sans-serif; font-size: 16px; color: rgb(0, 0, 0); padding-left: 5px; margin-left: 0px; border-left: 2px solid rgb(0, 0, 255); text-decoration: none;"><malik(dot)a(dot)rumi(at)gmail(dot)com style=""><div dir="ltr" style=""><div style="font-size: 10pt; color: black; font-style: normal; font-weight: normal;">1. What is your operating&nbsp;system? It looks like Windows, but I'm not sure. Also what version number for the OS?</div><div style="font-size: 10pt; color: black; font-style: normal; font-weight: normal;"><span style="font-size: 10pt;"><br></span></div><div style="font-size: 10pt; color: rgb(0, 0, 0); font-style: normal;"><span style="font-size: 10pt;"><font color="#c10066" style=""><b>Windows 10&nbsp;</b></font></span></div><div style="font-size: 10pt; color: rgb(0, 0, 0); font-style: normal;"><span style="font-size: 10pt;"><font color="#c10066" style=""><b>Version 1803 (OS Build 17134.407)</b></font></span></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2"><br></font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2">2. Look in the url. You are at 127.0.0.1. That is the same as localhost. But then it says 49194.&nbsp;</font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2"><br></font></div><div style="color: rgb(0, 0, 0); font-style: normal;"><font color="#c10066" style="" size="2"><b>I don't see 49194.</b></font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2"><br></font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2">Postgres uses 5432 by default. That's why you got that part of the error&nbsp;message, but we need a lot more detail to help you.&nbsp;</font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2"><br></font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2">3. It might be that your OS is too old to run the more recent versions of Postgres. I don't use Windows anymore, but I know you have to be at Ubuntu 18 to run PG 10&nbsp;+, there's probably something similar in Windows. That is one of the many reasons why knowing your OS is important information.</font></div><div style="color: black; font-style: normal; font-weight: normal;"><font size="2">---------------------------------------------</font></div><div style="color: rgb(0, 0, 0);"><font size="2"><i style="">Another reply</i><br><br><span style="font-style: normal; font-family: Geneva, Arial, Helvetica, sans-serif;">How come.&nbsp; (Are you running a really old distro version?)<br><br><font color="#c10066" style=""><b>No.</b></font></span></font></div><div style="color: rgb(0, 0, 0);"><span style="font-style: normal; font-family: Geneva, Arial, Helvetica, sans-serif;"><font color="#c10066" style="" size="2"><b><br></b></font></span></div><div style="color: rgb(0, 0, 0);"><font size="2"><span style="font-family: Geneva, Arial, Helvetica, sans-serif;">Well,&nbsp;</span><b style="font-family: Geneva, Arial, Helvetica, sans-serif;">is</b><span style="font-family: Geneva, Arial, Helvetica, sans-serif;">&nbsp;Postgres running?&nbsp; You installed Pg but did you start it?&nbsp;&nbsp;</span></font></div><div style="color: rgb(0, 0, 0);"><span style="font-family: Geneva, Arial, Helvetica, sans-serif;"><font size="2"><br></font></span></div><div style=""><font size="2"><span style="font-family: Geneva, Arial, Helvetica, sans-serif;"><font color="#c10066"><b>I can launch pgAdmin, but I cannot log into postgres. Instead I receive the error message cited below.</b></font></span><br style="font-family: Geneva, Arial, Helvetica, sans-serif;"><br style="font-family: Geneva, Arial, Helvetica, sans-serif;"><span style="color: rgb(0, 0, 0); font-family: Geneva, Arial, Helvetica, sans-serif;">These two commands will tell you:<br></span><span style="color: rgb(0, 0, 0); font-family: Geneva, Arial, Helvetica, sans-serif;">pg_ctl status # when logged in as user postgres</span><br style="font-family: Geneva, Arial, Helvetica, sans-serif;"><span style="color: rgb(0, 0, 0); font-family: Geneva, Arial, Helvetica, sans-serif;">sudo netstat -an | grep 5432</span></font></div><div style="font-size: 10pt; color: black; font-style: normal; font-weight: normal;"><br></div></div><br><div class="gmail_quote" style="font-size: 10pt; color: black; font-style: normal; font-weight: normal;"><div dir="ltr">On Fri, Nov 23, 2018 at 8:31 PM Anne Marie Harm &lt;<a target="_blank" href="mailto:amharm(at)earthlink(dot)net">amharm(at)earthlink(dot)net</a>&gt; wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:16px;color:rgb(0,0,0);font-family:georgia,serif">Hello,&nbsp;<br><span style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px"></span><font face="georgia, serif" style="font-size:12px"><span style="font-size:16px"><br>Unfortunately I'm unable to operate pgAdmin/PostgreSQL; first of all I can only install version 9.5 (tried versions 11, 10, and 9.6 -- but cannot install). When I launch pgAdmin in order to try to use PostgreSGL 9.5, h</span></font>ere is the full text of the error message I receive (also, screenshot attached):<span style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px"></span><div style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px;margin:0px"><font face="georgia, serif"><span style="font-size:16px"><br></span></font></div><div style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px;margin:0px"><font face="georgia, serif"><span style="font-size:16px">could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?</span></font></div><div style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px;margin:0px"><font face="georgia, serif"><span style="font-size:16px"><br></span></font></div><div style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px;margin:0px"><font face="georgia, serif"><span style="font-size:16px">Please advise; thank you. ~ Anne Marie</span></font></div><div id="m_-476432094254236012elnk_signature_1543025315135" style="font-family:arial,sans-serif;font-size:10pt;margin:0px"><pre style="font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:1em;line-height:normal;font-family:&quot;Courier New&quot;,&quot;Lucida Sans Typewriter&quot;,monospace">----------------------------
Anne Marie Harm
(312) 563-9397
<a target="_blank" href="mailto:amharm(at)earthlink(dot)net">amharm(at)earthlink(dot)net</a>
<a target="_blank" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieha</a>rm</pre></div></div></div></blockquote></div></malik(dot)a(dot)rumi(at)gmail(dot)com></blockquote><br><br></div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 8.7 KB

Browse pgadmin-support by date

  From Date Subject
Next Message Ron 2018-11-24 18:10:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Malik Rumi 2018-11-24 16:00:51 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2018-11-24 18:10:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Malik Rumi 2018-11-24 16:00:51 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL