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

From: Ray O'Donnell <ray(at)rodonnell(dot)ie>
To: Malik Rumi <malik(dot)a(dot)rumi(at)gmail(dot)com>, amharm(at)earthlink(dot)net
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Date: 2018-11-24 13:37:00
Message-ID: 349b5038-66ab-fba5-9c31-3c6fea852527@rodonnell.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-hackers

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 24/11/18 13:26, Malik Rumi wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAKd6oBzRLHqWCXG1DH7j-9f0JSExLk2-xBmUsSrPU+OJmhcPeQ(at)mail(dot)gmail(dot)com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">
<div>1. What is your operating system? It looks like Windows,
but I'm not sure. Also what version number for the OS?</div>
<div>2. Look in the url. You are at 127.0.0.1. That is the same
as localhost. But then it says 49194. Postgres uses 5432 by
default. That's why you got that part of the error message,
but we need a lot more detail to help you. </div>
<div>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 +, there's
probably something similar in Windows. That is one of the many
reasons why knowing your OS is important information.</div>
<div><br>
</div>
<br clear="all">
<div>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr"><strong
style="color:rgb(0,0,0);font-family:Tahoma,sans-serif;font-size:12px;letter-spacing:0.5px"><em>“None
of you has faith until he loves for his brother or his
neighbor what he loves for himself.”</em></strong><br>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Fri, Nov 23, 2018 at 8:31 PM Anne Marie Harm
&lt;<a href="mailto:amharm(at)earthlink(dot)net"
moz-do-not-send="true">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, <br>
<span
style="font-family:Geneva,Arial,Helvetica,sans-serif;font-size:12px"></span><font
style="font-size:12px" face="georgia, serif"><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>
</div>
</blockquote>
</div>
</blockquote>
<br>
[Removed pgsql-hackers and pgsql-admin, as this question is about
pgAdmin]<br>
<br>
In addition to what Malik has said above, you might have a mix-up
between IPv4 and IPv6 - the error message above indicates that
pgAdmin is trying to connect using IPv6.<br>
<br>
Ray.<br>
<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 4.2 KB

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Michael Banck 2018-11-24 13:47:31 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Malik Rumi 2018-11-24 13:26:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Banck 2018-11-24 13:47:31 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Malik Rumi 2018-11-24 13:26:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Banck 2018-11-24 13:47:31 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Malik Rumi 2018-11-24 13:26:58 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL