could not connect to server, in order to operate pgAdmin/PostgreSQL
On 11/23/2018 08:31 PM, Anne Marie Harm wrote:
Hello,
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).
How come. (Are you running a really old distro version?)
When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the
full text of the error message I receive (also, screenshot attached):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?
Well, *is* Postgres running? You installed Pg but did you start it? These
two commands will tell you:
pg_ctl status # when logged in as user postgres
sudo netstat -an | grep 5432
--
Angular momentum makes the world go 'round.
Hello,
You must be check postgres.conf file in order to see the particular port.
Sometimes postgres is running but in another port 5433, 5434, etc.
Obtener Outlook para Android<https://aka.ms/ghei36>
________________________________
From: Ron <ronljohnsonjr@gmail.com>
Sent: Saturday, November 24, 2018 3:25:02 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
On 11/23/2018 08:31 PM, Anne Marie Harm wrote:
Hello,
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).
How come. (Are you running a really old distro version?)
When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the full text of the error message I receive (also, screenshot attached):
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?
Well, is Postgres running? You installed Pg but did you start it? These two commands will tell you:
pg_ctl status # when logged in as user postgres
sudo netstat -an | grep 5432
--
Angular momentum makes the world go 'round.
1. What is your operating system? It looks like Windows, but I'm not sure.
Also what version number for the OS?
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.
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.
*“None of you has faith until he loves for his brother or his neighbor what
he loves for himself.”*
On Fri, Nov 23, 2018 at 8:31 PM Anne Marie Harm <amharm@earthlink.net>
wrote:
Show quoted text
Hello,
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, here
is the full text of the error message I receive (also, screenshot attached):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?Please advise; thank you. ~ Anne Marie
----------------------------
Anne Marie Harm
(312) 563-9397amharm@earthlink.nethttps://www.linkedin.com/in/annemarieharm/
<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@mail.gmail.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
<<a href="mailto:amharm@earthlink.net"
moz-do-not-send="true">amharm@earthlink.net</a>> 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>
Hi,
(no need to cross-post this to all of pgadmin-support, -admin and
-hackers, I've removed pgadmin-support and -hackers)
On Sat, Nov 24, 2018 at 07:26:58AM -0600, Malik Rumi wrote:
I don't use Windows anymore, but I know you have to be at Ubuntu
18 to run PG 10 +,
That's not true, the Postgres project supports all Postgres versions on
all Ubuntu LTS versions at https://apt.postgresql.org.
Michael
A little off topic, but I clearly remember getting an error message when
trying to upgrade to PG 10 while still on Ubuntu 16, and seeing a blog post
to the same effect. I can't cite you to them now, of course, that was all
months ago, but that's where I got the info. It could easily have been
wrong, of course, but it was out there at the time.
*“None of you has faith until he loves for his brother or his neighbor what
he loves for himself.”*
On Sat, Nov 24, 2018 at 7:49 AM Michael Banck <mbanck@debian.org> wrote:
Show quoted text
Hi,
(no need to cross-post this to all of pgadmin-support, -admin and
-hackers, I've removed pgadmin-support and -hackers)On Sat, Nov 24, 2018 at 07:26:58AM -0600, Malik Rumi wrote:
I don't use Windows anymore, but I know you have to be at Ubuntu
18 to run PG 10 +,That's not true, the Postgres project supports all Postgres versions on
all Ubuntu LTS versions at https://apt.postgresql.org.Michael
By default???
On 11/24/2018 06:16 AM, Ricardo Martin Gomez wrote:
Hello,
You must be check postgres.conf file in order to see the particular port.
Sometimes postgres is running but in another port 5433, 5434, etc.Obtener Outlook para Android <https://aka.ms/ghei36>
----------------------------------------------------------------------------
*From:* Ron <ronljohnsonjr@gmail.com>
*Sent:* Saturday, November 24, 2018 3:25:02 AM
*To:* pgsql-admin@lists.postgresql.org
*Subject:* Re: could not connect to server, in order to operate
pgAdmin/PostgreSQL
On 11/23/2018 08:31 PM, Anne Marie Harm wrote:Hello,
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).How come. (Are you running a really old distro version?)
When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the
full text of the error message I receive (also, screenshot attached):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?Well, *is* Postgres running? You installed Pg but did you start it?
These two commands will tell you:pg_ctl status # when logged in as user postgres
sudo netstat -an | grep 5432--
Angular momentum makes the world go 'round.
--
Angular momentum makes the world go 'round.
On Sat, Nov 24, 2018 at 8:01 AM Anne Marie Harm <amharm@earthlink.net>
wrote:
Hello,
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, here
is the full text of the error message I receive (also, screenshot attached):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?Are you able to login with the same credentials via psql?
Please confirm.
Show quoted text
Please advise; thank you. ~ Anne Marie
----------------------------
Anne Marie Harm
(312) 563-9397amharm@earthlink.nethttps://www.linkedin.com/in/annemarieharm/