Re: The server does not listen

Thank you Adarsh,

> Il 16 ottobre 2017 alle 16.31 Adarsh Jaiswal <adarshjaiswal1989(at)gmail(dot)com> ha scritto:
>
> 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.
>

sudo: /etc/init.d/postgresql: command not found

> 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.
>

sudo: /etc/init.d/postgresql: command not found

> 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.
>

In the log file there is not postgresql ! (see here https://www.dropbox.com/s/46n3mv603jy3eaz/Senza%20titolo.tiff?dl=0)

My last log was on May (see my first email with link to the image: https://www.dropbox.com/sh/60onx881lrzwpgf/AAAa0iOBzfm0n1Jd5LD7sdg_a?dl=0 )

After that time, I had problems in June with my Os, so a technician made an upgrade to OS El Captain. And here I am!

Bests,

Mauro

> Thanks and Regards,
> Adarsh Jaiswal
>
> On Mon, Oct 16, 2017 at 7:51 PM, <manno_it(at)libero(dot)it mailto: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 mailto: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 mailto: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 mailto: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 mailto: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 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
> > > > > >
> > > > > > > > > > >
> > > > >
> > > > > > > > >
> > > > > > >
> > >
> > > > >
> > >
>