Re: [NOVICE] Allowing a connection from other client in the network

"Oliveiros Cristina" <oliveiros.cristina@marktest.pt> writes:
> 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;

This is incorrect. listen_addresses must specify the interface addresses of your *own* machine, not some other one. Usually if you want to allow remote connections, you should just set it to '*' and let the postmaster figure out what the machine's IP address(es) are.

> 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

This part's OK.

You might also have a third problem: if the machine has any sort of firewall software, the firewall might need to be adjusted to let in remote connections to port 5432.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

                        regards, tom lane

---------------------------(end of broadcast)---------------------------