getting an error while connecting remotely and the error says something like
could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host x and accepting TCP/IP connections on port 5432?
please help me out
Open your terminal and write
service postgresql status
If it says it is not running than write
service postgresql start
If the service is already running then check the listening port of your postgresql service via
netstat -an | grep postgresql
and the result will show the port it is listening.And then you can connect your database with the command
psql -h localhost -p port_you_found -U postgres
User contributions licensed under CC BY-SA 3.0