Re: The server does not listen

>
> On Mon, Oct 16, 2017 at 11:24 AM, Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
> wrote:
>
>> Il 16/10/2017 16:50, manno_it(at)libero(dot)it ha scritto:
>>
>> Thank you Moreno,
>>
>>
>> And how to "start the service"?
>> In the same terminal, run
>> sudo /etc/init.d/postgresql start
>>
>> It will give you feedback on startup ([OK] or [FAIL])
>>
>> In my etc folder there is not a init.d file...: see the findings of a ls
>> in this txt file: https://www.dropbox.com/s/4m7a9n17ensr6ri/Output%20di%
>> 20Terminale%20salvato?dl=0
>>
>> I think this coul be useful
>> https://stackoverflow.com/questions/7975556/how-to-start-
>> postgresql-server-on-mac-os-x
>> 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.
>> I saw many results while googling, so similar searches should let you
>> acquire more informations.
>>
>> HTH
>> Moreno.
>>
>
How did you install postgres? Did you use the package or did you compile it
from source? If you compiled it, you will have to manually create a service
for postgres. But to start the database without the service, you can use
pg_ctl directly:

pg_ctl -D <your-data-directory-full-path> start

Thanks,

Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

>
> Thanks,
>
> M
>
>
>
>
> Thank you,
>
> mauro
>
>
> 16 ottobre 2017 alle 13.16 Adarsh Jaiswal <adarshjaiswal1989(at)gmail(dot)com>
> <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
>
>
>
>
>
>