Re: Remote connection issues

On 23/06/2011 08:24, Aritz Dávila wrote:
> Hi list,
>
> I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
> remote access to this database so after reading I found out that modifying
> pg_hba.conf and postgresql.conf will allow me to access remotely.
>
> The postgresql database is on 192.168.2.122. The port 5432 is open, checked it
> with nmap -p1-65535 localhost. The server is comunicating with other pcs from
> the subnet, I can connect to it through ssh.
>
> Here is what I have done:
> I enabled the following on the postgresql.conf file:
> listen_addresses = '*'
> port = 5432
>
> My subnet is under 192.168.2.xxx so I added the following to the pg_hba.conf:
> host all all 192.168.2.0/32 trust

Should that be /24?

Mind you, that gives unchallenged access to the server from all hosts on
that subnet, so maybe this isn't what you want. However, bear in mind
that sequence is important in pg_hba.conf, so the first matching rule is
what will be enforced.

> After doing all this things, if I try to connect remotely I got a connection
> refused error.
> psql -h 192.168.2.122 -d database
> psql: could not connect to server: Connection refused
> Is the server running on host "192.168.2.122" and accepting
> TCP/IP connections on port 5432?

Having said all the above, this doesn't look like a pg_hba.conf error; a
refusal based on that file says so explicitly in the error message.
Could it be a firewall or iptables problem?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie