Re: The server does not listen

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: manno_it(at)libero(dot)it, pgsql-novice(at)postgresql(dot)org
Subject: Re: The server does not listen
Date: 2017-10-16 15:24:04
Message-ID: 238b409c-b54a-c846-dc94-486360a63772@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Il 16/10/2017 16:50, <a class="moz-txt-link-abbreviated" href="mailto:manno_it(at)libero(dot)it">manno_it(at)libero(dot)it</a>
ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:1942926150(dot)889196(dot)1508165409795(at)mail(dot)libero(dot)it">
<meta charset="UTF-8">
<p>Thank you Moreno,<br>
</p>
<blockquote type="cite"><br id="ox-ffd36cd688">
<p>And how to "start the service"?<br>
</p>
In the same terminal, run<br>
sudo /etc/init.d/postgresql start<br>
<br>
It will give you feedback on startup ([OK] or [FAIL])<br>
</blockquote>
<p>In my etc folder there is not a init.d file...: see the
findings of a ls in this txt file: <a
href="https://www.dropbox.com/s/4m7a9n17ensr6ri/Output%20di%20Terminale%20salvato?dl=0"
moz-do-not-send="true">https://www.dropbox.com/s/4m7a9n17ensr6ri/Output%20di%20Terminale%20salvato?dl=0</a><br>
</p>
</blockquote>
I think this coul be useful<br>
<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/7975556/how-to-start-postgresql-server-on-mac-os-x">https://stackoverflow.com/questions/7975556/how-to-start-postgresql-server-on-mac-os-x</a><br>
I'm not a Mac expert, so I can't go further (and I've got no Mac
around me to do a quick check), just take a look and see if it
helps.<br>
I saw many results while googling, so similar searches should let
you acquire more informations.<br>
<br>
HTH<br>
Moreno.<br>
<br>
<blockquote type="cite"
cite="mid:1942926150(dot)889196(dot)1508165409795(at)mail(dot)libero(dot)it">
<p>Thanks,<br>
</p>
<p>M<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<blockquote type="cite">Thank you,
<blockquote type="cite">
<p> mauro<br>
</p>
<p><br>
</p>
<p>16 ottobre 2017 alle 13.16 Adarsh Jaiswal <a
class="ox-ffd36cd688-moz-txt-link-rfc2396E"
href="mailto:adarshjaiswal1989(at)gmail(dot)com"
moz-do-not-send="true">&lt;adarshjaiswal1989(at)gmail(dot)com&gt;</a>
ha scritto:<br>
</p>
<blockquote type="cite"><br>
<div dir="ltr">Hi,
<div><br>
</div>
<div>Check if the service is running.
(/etc/init.d/postgresql status)</div>
<div><br>
</div>
<div>Start the service if not running and check the logs
(location in the earlier email)</div>
</div>
<div class="ox-ffd36cd688-ox-27e1c318ba-gmail_extra"><br
clear="all">
<div>
<div class="ox-ffd36cd688-ox-27e1c318ba-gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Thanks and Regards,</div>
<div>Adarsh Jaiswal</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="ox-ffd36cd688-ox-27e1c318ba-gmail_quote">On
Mon, Oct 16, 2017 at 4:43 PM, &lt;<a
href="mailto:manno_it(at)libero(dot)it" target="_blank"
moz-do-not-send="true">manno_it(at)libero(dot)it</a>&gt;
wrote:<br>
<blockquote>
<div>
<p>Dear all,<br>
</p>
<p>thank you for your reply.<br>
</p>
<p>Here my findings:<br>
</p>
<p>Port Scanning host: 127.0.0.1<br>
<br>
<em>     Open TCP Port:     22             ssh</em><br>
<em>     Open TCP Port:     631            ipp</em><br>
<em>     Open TCP Port:     3306           mysql</em><br>
<em>     Open TCP Port:     4370</em><br>
<em>     Open TCP Port:     4380</em><br>
<em>     Open TCP Port:     8080         
 http-alt</em><br>
<em>Esamina Porte completato...</em><br>
</p>
<p><br>
</p>
<p>Unfortunatly the port 5432 is not open or does
not show postgresql...<br>
</p>
<p>Bests,<br>
</p>
<p>mauro</p>
<div>
<div class="ox-ffd36cd688-ox-27e1c318ba-h5">
<blockquote type="cite">Il 16 ottobre 2017 alle
5.25 Adarsh Jaiswal &lt;<a
href="mailto:adarshjaiswal1989(at)gmail(dot)com"
target="_blank" moz-do-not-send="true">adarshjaiswal1989(at)gmail(dot)com</a>&gt;
ha scritto:<br>
<br>
<div dir="ltr">Hi,
<div><br>
</div>
<div>Try checking if the service is started
and listening on port 5432.</div>
<div><br>
</div>
<div>You can use netstat command to check
it.</div>
<div><br>
</div>
<div>netstat -nalp | grep :5432</div>
<div><br>
</div>
<div><br>
</div>
<div>Also , check the latest logs of the
postgres when you start the engine, what
it is saying. We can get the logs usually
at the location "/var/log/postgresql"</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div
class="ox-ffd36cd688-ox-27e1c318ba-m_-1332347896998675706ox-ddf23d9364-gmail_extra"><br
clear="all">
<div>
<div
class="ox-ffd36cd688-ox-27e1c318ba-m_-1332347896998675706ox-ddf23d9364-gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Thanks and Regards,</div>
<div>Adarsh Jaiswal</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div
class="ox-ffd36cd688-ox-27e1c318ba-m_-1332347896998675706ox-ddf23d9364-gmail_quote">On
Sun, Oct 15, 2017 at 6:30 PM, &lt;<a
href="mailto:manno_it(at)libero(dot)it"
target="_blank" moz-do-not-send="true">manno_it(at)libero(dot)it</a>&gt;
wrote:<br>
<blockquote>
<div>
<p>Hello,<br>
</p>
<p>I am running Postgres 9.2 on a
MacOs X El Captain 10.11.6. I start
my database named <em>posgres</em>
last time in May. [After that, I had
problems on my Mac, so I
re-installad and upgraded the OS ti
El Captain.] Now I'm trying to
connect to my database by
PgAdminIII, Navicat and so on, but
it seems impossibile to start a
connection: "The server does not
listen". I have tried to find a
solution in the Postgres
documentation, under the Appendices
(Installation, starting the database
etc.), but I am not able to find a
solution.<br>
</p>
<p>I have a basic knowledge of linux
commands, shell, privileges etc. <br>
</p>
<p>I will attach here some screenshot
with the error messages: <a
href="https://www.dropbox.com/sh/60onx881lrzwpgf/AAAa0iOBzfm0n1Jd5LD7sdg_a?dl=0"
target="_blank"
moz-do-not-send="true">https://www.dropbox.com/sh/60o<wbr>nx881lrzwpgf/AAAa0iOBzfm0n1Jd5<wbr>LD7sdg_a?dl=0</a><br>
</p>
<p>Could anyone help me (a) to
understand what the problem exactly
is and (b) how to find a solution?
Hope my tables and data are there!!<br>
</p>
<p>Thank you very much for you
attention,<br>
Mauro - IT</p>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</blockquote>
<p><br>
</p>
</blockquote>
</blockquote>
<p><br>
</p>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 10.5 KB

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Payal Singh 2017-10-16 18:10:52 Re: The server does not listen
Previous Message manno_it 2017-10-16 14:50:09 Re: The server does not listen