| From: | Anne Marie Harm <amharm(at)earthlink(dot)net> |
|---|---|
| To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgSQL admin support list <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: could not connect to server, in order to operate pgAdmin/PostgreSQL |
| Date: | 2018-11-29 20:48:29 |
| Message-ID: | 912299242.10600.1543524509688@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?<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: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
<br>Sent: Nov 25, 2018 3:37 AM
<br>To: 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 text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<div class="moz-cite-prefix">On 24/11/18 9:32 μ.μ., Anne Marie Harm
wrote:<br>
</div>
<blockquote type="cite" cite="mid:1882688338(dot)3266(dot)1543087934594(at)wamui-napoleon(dot)atl(dot)sa(dot)earthlink(dot)net">
<zzzmeta http-equiv="content-type" content="text/html; charset=UTF-8">
<style type="text/css"><ZZZ!-- DIV {margin:0px;} --></style>
<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 style="font-family: georgia, serif; font-size: 16px;" face="georgia, serif"><span style="font-size: small;">Oddly
enough I did not receive </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">> You must be check
postgres.conf file in order to see the particular
port.</font><br>
<font face="sans-serif">> </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 style="font-family: georgia, serif;" size="2" face="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>
</font></div>
</zzzmeta></blockquote>
<p><br>
</p>
<p>It depends who you installed PostgreSQL. It could be in
~postgres/data , e.g. /var/lib/pgsql/data or
/usr/local/var/pgsql/data , or just echo $PGDATA to find out, or
do <br>
</p>
<p>ps aux | egrep -e 'postgres \-D'</p>
<p>and look at the dir after -D . Usually postgresql.conf (and
postgresql.auto.conf ) are in there.</p>
<p>If you are running debian look in /etc/postgresql/<insert your
pgsql major version>/<your cluster name>/postgresql.conf</p>
<p>You could find those out also by :</p>
<p>postgres(at)achill-XPS-15-9550:~$ psql<br>
psql (10.6 (Ubuntu 10.6-0ubuntu0.18.04.1))<br>
Type "help" for help.<br>
<br>
postgres=# show data_directory ;<br>
data_directory <br>
-----------------------------<br>
/var/lib/postgresql/10/main<br>
(1 row)<br>
<br>
postgres=# show config_file ;<br>
config_file <br>
-----------------------------------------<br>
/etc/postgresql/10/main/postgresql.conf<br>
(1 row)<br>
<br>
postgres=# <br>
<br>
</p>
<p><br>
</p>
<blockquote type="cite" cite="mid:1882688338(dot)3266(dot)1543087934594(at)wamui-napoleon(dot)atl(dot)sa(dot)earthlink(dot)net">
<div style="font-size: 16px;color: rgb(0, 0, 0);font-family:
georgia, serif;"><font style="font-family: georgia, serif;" size="2" face="georgia, serif"><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>>
By default???</span><font style="font-family: georgia, serif;" size="2" face="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: <a class="moz-txt-link-rfc2396E" href="mailto:pgsql-admin(at)lists(dot)postgresql(dot)org">"pgsql-admin(at)lists(dot)postgresql(dot)org"</a> <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" face="Calibri,
sans-serif" color="#000000"><b>From:</b>
Ron <a target="_blank" class="moz-txt-link-rfc2396E" href="mailto:ronljohnsonjr(at)gmail(dot)com" moz-do-not-send="true"><ronljohnsonjr(at)gmail(dot)com></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" moz-do-not-send="true">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> </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, <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. (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? You
installed Pg but did you start it? 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
<a class="moz-txt-link-abbreviated" href="mailto:amharm(at)earthlink(dot)net">amharm(at)earthlink(dot)net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieharm/</a></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
<a class="moz-txt-link-abbreviated" href="mailto:amharm(at)earthlink(dot)net">amharm(at)earthlink(dot)net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieharm/</a></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
<a class="moz-txt-link-abbreviated" href="mailto:amharm(at)earthlink(dot)net">amharm(at)earthlink(dot)net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieharm/</a></pre>
</div>
<br>
<br>
</div>
</blockquote>
</zzzbody>
</zzzhtml>
</achill(at)matrix(dot)gatewaynet(dot)com></blockquote><br><div id="elnk_signature_1543524500875" 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 | 15.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | prasanna rk | 2018-11-30 03:46:37 | Disable copy function |
| Previous Message | Anne Marie Harm | 2018-11-29 20:47:52 | Re: could not connect to server, in order to operate pgAdmin/PostgreSQL |