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@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
