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

From: Anne Marie Harm <amharm(at)earthlink(dot)net>
To: Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Ron <ronljohnsonjr(at)gmail(dot)com>
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Date: 2018-11-29 20:47:52
Message-ID: 1134330703.10587.1543524472631@wamui-cinderella.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;">Do you know the Windows path to the postgres.conf file?<div><br><br><blockquote style="padding-left: 5px; margin-left: 0px; border-left: #0000ff 2px solid; font-weight: normal; font-style: normal; text-decoration: none; font-size: 10pt; font-family: arial,sans-serif; color: black;">-----Original Message-----
<br>From: Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com>
<br>Sent: Nov 24, 2018 7:16 AM
<br>To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, Ron <ronljohnsonjr(at)gmail(dot)com>
<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=us-ascii">
<zzzmeta content="text/html; charset=utf-8">
</zzzmeta></zzzmeta></zzzhead>
<zzzbody bgcolor="#FFFFFF">
<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">Outlook para Android</a></div>
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Ron &lt;ronljohnsonjr(at)gmail(dot)com&gt;<br>
<b>Sent:</b> Saturday, November 24, 2018 3:25:02 AM<br>
<b>To:</b> pgsql-admin(at)lists(dot)postgresql(dot)org<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 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).</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 face="georgia,
serif" style="font-size:12px"><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>
</zzzbody>
</zzzhtml>
</ronljohnsonjr(at)gmail(dot)com></pgsql-admin(at)lists(dot)postgresql(dot)org></rimartingomez(at)hotmail(dot)com></blockquote><br><div id="elnk_signature_1543524437183" 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></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 4.7 KB

Browse pgsql-admin by date

  From Date Subject
Next Message Anne Marie Harm 2018-11-29 20:48:29 Re: could not connect to server, in order to operate pgAdmin/PostgreSQL
Previous Message Laurenz Albe 2018-11-29 16:32:41 Re: Keeping /data directory on dNFS share makes it extremely slow ad not usable