im having trouble connecting to my postgresql server remotely

titus123 — Thu, 03 Jan 2019 18:05:11 GMT

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

Re: im having trouble connecting to my postgresql server remotely

bmejias1 — Mon, 11 Feb 2019 09:20:27 GMT

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

topic Re: im having trouble connecting to my postgresql server remotely in Alfresco Forum

im having trouble connecting to my postgresql server remotely

Re: im having trouble connecting to my postgresql server remotely