<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:21, <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:1326919301(dot)886958(dot)1508163711320(at)mail(dot)libero(dot)it">
<meta charset="UTF-8">
<p>Hemmm, </p>
<p>thank you Adarsh, but how can I check the status via
/etc/init.d/postgresql status ? In the shell with sudo? I'm not
an expert on linux... <br>
</p>
</blockquote>
<br>
in a terminal run (no need for sudo)<br>
<br>
moreno(at)test:~$ /etc/init.d/postgresql status<br>
● postgresql.service - PostgreSQL RDBMS<br>
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled)<br>
Active: active (exited) since mar 2017-09-26 16:34:23 CEST; 2
weeks 5 days ago<br>
Process: 15540 ExecStart=/bin/true (code=exited, status=0/SUCCESS)<br>
Main PID: 15540 (code=exited, status=0/SUCCESS)<br>
CGroup: /system.slice/postgresql.service<br>
<br>
<blockquote type="cite"
cite="mid:1326919301(dot)886958(dot)1508163711320(at)mail(dot)libero(dot)it">
<p>And how to "start the service"?<br>
</p>
</blockquote>
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>
<br>
Cheers,<br>
Moreno.<br>
<br>
<blockquote type="cite"
cite="mid:1326919301(dot)886958(dot)1508163711320(at)mail(dot)libero(dot)it">
<p>Thank you,<br>
mauro<br>
</p>
<p><br>
</p>
<p>16 ottobre 2017 alle 13.16 Adarsh Jaiswal
<a class="moz-txt-link-rfc2396E" href="mailto:adarshjaiswal1989(at)gmail(dot)com"><adarshjaiswal1989(at)gmail(dot)com></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-27e1c318ba-gmail_extra"><br clear="all">
<div>
<div class="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-27e1c318ba-gmail_quote">On Mon, Oct 16, 2017 at
4:43 PM, <<a href="mailto:manno_it(at)libero(dot)it"
target="_blank" moz-do-not-send="true">manno_it(at)libero(dot)it</a>>
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-27e1c318ba-h5">
<blockquote type="cite">Il 16 ottobre 2017 alle 5.25
Adarsh Jaiswal <<a
href="mailto:adarshjaiswal1989(at)gmail(dot)com"
target="_blank" moz-do-not-send="true">adarshjaiswal1989(at)gmail(dot)com</a>>
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-27e1c318ba-m_-1332347896998675706ox-ddf23d9364-gmail_extra"><br
clear="all">
<div>
<div
class="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-27e1c318ba-m_-1332347896998675706ox-ddf23d9364-gmail_quote">On
Sun, Oct 15, 2017 at 6:30 PM, <<a
href="mailto:manno_it(at)libero(dot)it"
target="_blank" moz-do-not-send="true">manno_it(at)libero(dot)it</a>>
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>
</body>
</html>