What am I suppose to change in pg_hba.conf file?
Regards, Anuj Pankaj From: Igor Neyman [mailto:iney...@perceptron.com] Sent: Thursday, September 30, 2010 6:49 PM To: Anuj Pankaj; pgsql-admin@postgresql.org Subject: RE: could not connect to server: Connection refused (0x0000274D/10061) ________________________________ From: Anuj Pankaj [mailto:an...@cybage.com] Sent: Wednesday, September 29, 2010 8:57 AM To: pgsql-admin@postgresql.org Subject: could not connect to server: Connection refused (0x0000274D/10061) Hi, I installed Postgres 8.1.4 on Linux and postgres server is running and I successfully created database on local machine. I modified listen_addresses = '*' in Postgresql.conf and however If I try to access postgres through pgAdmin III. I am sticking with an exception. Exception is: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "192.168.9.126" and accepting TCP/IP connections on port 5432? Thanks & Regards, Anuj Pankaj "Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment." www.cybage.com [I.N.] Do you have proper configuration (that allows network connections) in your pg_hba.conf file? Regards, Igor Neyman "Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment." www.cybage.com