Re: connecting to pgsql

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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of mmaclennan
Sent: Thursday, February 16, 2006 11:38 PM
To: pgsql-general@postgresql.org
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