im having trouble connecting to my postgresql server remotely

cancel
Showing results for 
Search instead for 
Did you mean: 
titus123
Member II

im having trouble connecting to my postgresql server remotely

it keeps giving me this error "could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "10.9.0.101" and accepting TCP/IP connections on port 5432?" 

Ive configured all the necessary files still keep getting the error ive attached my configuration files

1 Reply
bmejias1
Active Member

Re: im having trouble connecting to my postgresql server remotely

Hi Titus,

A bit late to answer this question but I see it's still open, so here you go:

Your postgresql.conf looks fine, it has:

listen_addresses = '*'

port = 5432

The problem is your host based authentication file pg_hba.conf. Until now you are only allowing connections from local host. Let's say your database is named: alfrescodb, and your user is alfresco. And imagine you are connecting from 10.9.0.42, then, you need to add the following line:

host    alfrescodb   alfresco   10.9.0.42/32   md5

And remove this line at the end:

host all     all         127.0.0.1/32                 password

Avoid using the 'password' method, as it sends the password on plain text.

I hope it helps

Boriss