Skip site navigation (1) Skip section navigation (2)

Allowing a connection from other client in the network

From: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Allowing a connection from other client in the network
Date: 2007-09-24 14:56:16
Message-ID: 002601c7febb$0f25bf60$ec5a3d0a@marktestcr.marktest.pt (view raw or flat)
Thread:
Lists: pgsql-novice
Hello, All,

I need to allow access to the postgres server(windows) from a remote machine (10.61.90.231).

I changed the postgresql.conf to include the line :

listen_addresses = 'localhost,10.61.90.231'  # what IP address(es) to listen on; 


And I changed the pg_hba.conf file (also on data dir) so now  it has a line like this

host    all         all         10.61.90.0/24          md5


And I rebooted the machine, but the server keeps on refusing actively connections.

Do I have to change any file besides these two ?

Help...

Many thanks in advance

Best,
Oliveiros

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2007-09-24 15:29:15
Subject: Re: Allowing a connection from other client in the network
Previous:From: Raimon FernandezDate: 2007-09-24 07:42:40
Subject: Cursors performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group