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

From: Anne Marie Harm <amharm(at)earthlink(dot)net>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(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 19:32:14
Message-ID: 1882688338.3266.1543087934594@wamui-napoleon.atl.sa.earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-size: 16px;color: rgb(0, 0, 0);font-family: georgia, serif;"><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" style="font-family: georgia, serif; font-size: 16px;"><span style="font-size: small;">Oddly enough I did not receive&nbsp;</span><span style="font-size: small;">Ricardo Martin Gomez</span></font><span style="font-family: georgia, serif; font-size: small;">'s response directly -- just received it with Ron's response.</span><br><blockquote type="cite" cite="mid:RO1P15201MB2267F8DCC9F82D673BA8818CA3D50(at)RO1P15201MB2267(dot)LAMP152(dot)PROD(dot)OUTLOOK(dot)COM" style="font-size: 13.3333px;"><zzzmeta http-equiv="Content-Type" content="text/html; charset=utf-8" style=""><zzzmeta content="text/html; charset=utf-8" style=""><div dir="auto" style="direction: ltr; margin: 0px; padding: 0px; font-size: 11pt;"><font face="georgia, serif">Regarding:</font><br><br><font face="sans-serif">&gt; You must be check postgres.conf file in order to see the particular port.</font><br><font face="sans-serif">&gt;&nbsp;</font><span style="font-family: sans-serif; font-size: 11pt;">Sometimes postgres is running but in another port 5433, 5434, etc.</span></div></zzzmeta></zzzmeta></blockquote><font face="georgia, serif" size="2" style="font-family: georgia, serif;">Where do I find that postgres. conf file; where and how do I look? (I have tried plenty of searching and trying what's suggested, to no avail.)<br><br>Not sure what to do with this, so I'll keep it in mind for future reference:<br><br></font><span style="font-size: 13.3333px;"><span style="white-space:pre"> </span>&gt; By default???</span><font face="georgia, serif" size="2" style="font-family: georgia, serif;"><br></font><div style="font-family: georgia, serif;"><font size="2"><br></font><blockquote style="font-size: 10pt; font-family: arial, sans-serif; padding-left: 5px; margin-left: 0px; border-left: 2px solid rgb(0, 0, 255); font-weight: normal; font-style: normal; text-decoration: none; color: black;">-----Original Message-----
<br>From: Ron <ronljohnsonjr(at)gmail(dot)com>
<br>Sent: Nov 24, 2018 1:10 PM
<br>To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
<br>Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

<br><br><zzzhtml>
<zzzhead>
<zzzmeta http-equiv="Content-Type" content="text/html; charset=utf-8">
</zzzmeta></zzzhead>
<zzzbody bgcolor="#FFFFFF" text="#000000">
By default???<br>
<br>
<div class="moz-cite-prefix">On 11/24/2018 06:16 AM, Ricardo Martin
Gomez wrote:<br>
</div>
<blockquote type="cite" cite="mid:RO1P15201MB2267F8DCC9F82D673BA8818CA3D50(at)RO1P15201MB2267(dot)LAMP152(dot)PROD(dot)OUTLOOK(dot)COM">
<zzzmeta http-equiv="Content-Type" content="text/html; charset=utf-8">
<zzzmeta content="text/html; charset=utf-8">
<div dir="auto" style="direction:ltr; margin:0; padding:0;
font-family:sans-serif; font-size:11pt; color:black">
Hello,<br>
</div>
<div dir="auto" style="direction:ltr; margin:0; padding:0;
font-family:sans-serif; font-size:11pt; color:black">
You must be check postgres.conf file in order to see the
particular port.<br>
</div>
<div dir="auto" style="direction:ltr; margin:0; padding:0;
font-family:sans-serif; font-size:11pt; color:black">
Sometimes postgres is running but in another port 5433, 5434,
etc.<br>
<br>
<br>
</div>
<div dir="auto" style="direction:ltr; margin:0; padding:0;
font-family:sans-serif; font-size:11pt; color:black">
<div dir="auto" style="direction:ltr; margin:0; padding:0;
font-family:sans-serif; font-size:11pt; color:black">
Obtener <a target="_blank" href="https://aka.ms/ghei36" moz-do-not-send="true">Outlook para Android</a></div>
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>From:</b> Ron
<a target="_blank" class="moz-txt-link-rfc2396E" href="mailto:ronljohnsonjr(at)gmail(dot)com">&lt;ronljohnsonjr(at)gmail(dot)com&gt;</a><br>
<b>Sent:</b> Saturday, November 24, 2018 3:25:02 AM<br>
<b>To:</b> <a target="_blank" class="moz-txt-link-abbreviated" href="mailto:pgsql-admin(at)lists(dot)postgresql(dot)org">pgsql-admin(at)lists(dot)postgresql(dot)org</a><br>
<b>Subject:</b> Re: could not connect to server, in order to
operate pgAdmin/PostgreSQL</font>
<div>&nbsp;</div>
</div>
<div>On 11/23/2018 08:31 PM, Anne Marie Harm wrote:<br>
<blockquote type="cite">
<style type="text/css">
<ZZZ!--
div
{margin:0px}
-->
</style>
<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 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).</span></font></div>
</blockquote>
<br>
How come.&nbsp; (Are you running a really old distro version?)<br>
<br>
<blockquote type="cite">
<div style="font-size:16px; color:rgb(0,0,0);
font-family:georgia,serif"><font style="font-size:12px" face="georgia, serif"><span style="font-size:16px">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>
</blockquote>
<br>
Well, <b>is</b> Postgres running?&nbsp; You installed Pg but did you
start it?&nbsp; These two commands will tell you:<br>
<br>
pg_ctl status # when logged in as user postgres<br>
sudo netstat -an | grep 5432<br>
<br>
-- <br>
<div class="moz-signature">Angular momentum makes the world go
'round.</div>
</div>
</zzzmeta></zzzmeta></blockquote>
<br>
<div class="moz-signature">-- <br>
Angular momentum makes the world go 'round.</div>
</zzzbody>
</zzzhtml>
</pgsql-admin(at)lists(dot)postgresql(dot)org></ronljohnsonjr(at)gmail(dot)com></blockquote><br><div id="elnk_signature_1543085724639" style="font-size: 10pt; font-family: arial, sans-serif; font-weight: normal; font-style: normal; text-decoration: none; color: black;"><pre>----------------------------
Anne Marie Harm
(312) 563-9397
amharm(at)earthlink(dot)net
https://www.linkedin.com/in/annemarieharm/</pre></div><br><br><br><div id="elnk_signature_1543086140256" style="font-size: 10pt; font-weight: normal; font-style: normal; text-decoration: none; font-family: arial, sans-serif; color: black;"><pre>----------------------------
Anne Marie Harm
(312) 563-9397
amharm(at)earthlink(dot)net
https://www.linkedin.com/in/annemarieharm/</pre></div><br><br></div><br><div id="elnk_signature_1543087914914" style="font-weight: normal; font-style: normal; text-decoration: none; font-size: 10pt; font-family: arial,sans-serif; color: black;"><pre>----------------------------
Anne Marie Harm
(312) 563-9397
amharm(at)earthlink(dot)net
https://www.linkedin.com/in/annemarieharm/</pre></div><br><br></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 8.6 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lentes, Bernd 2018-11-24 19:54:19 Re: User Authentication: LDAP and "local" accounts concurrently ?
Previous Message Laurenz Albe 2018-11-24 19:05:18 Re: canceling statement coming in slave instance