Did you make the required changes to pg_hba.conf?? Maybe you forgot to do those -Chandra Sekhar Surapaneni -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of mmaclennan Sent: Thursday, February 16, 2006 11:38 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] connecting to pgsql I have installed postgresql with postgis on a server at my home and I have loaded some data into it but I can not access this data from another computer. I have downloaded the ODBC driver from the postgresql web site and have installed it on another computer but when I try to establish a connection to postgres through microsoft access or arccatalogue I can not connect. The error I am receiving says that the connection was refused. I am positive I have the password right and the firewall is disabled but I still cannot connect. Has anyone experienced this problem before? Is there some default setting I have to change in postgres to allow other computers to access the db? Any help would be greatly appreiciated. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match