Re: The server does not listen

Hi,

Yes you are correct. We will have to run the commands in the shell via sudo
to check the status.

"/etc/init.d/postgresql status"

Share the status of the command above.

Similarly to start the Postgres Server , we will run the following command:

"/etc/init.d/postgresql start"

Then run the status command above and run command above and see if the
server is up.

If the server hasn't started, we need to check the log file. Open the log
file "/var/log/postgresql". We can check this by downloading the file and
viewing using a text editor.

Thanks and Regards,
Adarsh Jaiswal

On Mon, Oct 16, 2017 at 7:51 PM, <manno_it(at)libero(dot)it> wrote:

> Hemmm,
>
> 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...
>
> And how to "start the service"?
>
> Thank you,
> mauro
>
>
> 16 ottobre 2017 alle 13.16 Adarsh Jaiswal <adarshjaiswal1989(at)gmail(dot)com>
> ha scritto:
>
>
> Hi,
>
> Check if the service is running. (/etc/init.d/postgresql status)
>
> Start the service if not running and check the logs (location in the
> earlier email)
>
> Thanks and Regards,
> Adarsh Jaiswal
>
> On Mon, Oct 16, 2017 at 4:43 PM, <manno_it(at)libero(dot)it> wrote:
>
> Dear all,
>
> thank you for your reply.
>
> Here my findings:
>
> Port Scanning host: 127.0.0.1
>
> * Open TCP Port: 22 ssh*
> * Open TCP Port: 631 ipp*
> * Open TCP Port: 3306 mysql*
> * Open TCP Port: 4370*
> * Open TCP Port: 4380*
> * Open TCP Port: 8080 http-alt*
> *Esamina Porte completato...*
>
>
> Unfortunatly the port 5432 is not open or does not show postgresql...
>
> Bests,
>
> mauro
>
> Il 16 ottobre 2017 alle 5.25 Adarsh Jaiswal <adarshjaiswal1989(at)gmail(dot)com>
> ha scritto:
>
> Hi,
>
> Try checking if the service is started and listening on port 5432.
>
> You can use netstat command to check it.
>
> netstat -nalp | grep :5432
>
>
> 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"
>
>
>
> Thanks and Regards,
> Adarsh Jaiswal
>
> On Sun, Oct 15, 2017 at 6:30 PM, <manno_it(at)libero(dot)it> wrote:
>
> Hello,
>
> I am running Postgres 9.2 on a MacOs X El Captain 10.11.6. I start my
> database named *posgres* 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.
>
> I have a basic knowledge of linux commands, shell, privileges etc.
>
> I will attach here some screenshot with the error messages:
> https://www.dropbox.com/sh/60onx881lrzwpgf/AAAa0iOBzfm0n1Jd5LD7sdg_a?dl=0
>
> 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!!
>
> Thank you very much for you attention,
> Mauro - IT
>
>
>
>