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

Hi yeah I was doing some reading today and realized that I had to
change the pg_hba.conf file from local host to something else but I
don't wuite understand what I am suppose to be entering for the
CIDR-Address setting. This database will only be accessed from the
network and surrounding computers. The general Ip addresses for the
computers here are 192.168.1.X. Does this mean that the CIDR-Address
should be 192.168.1.0/24? This is what I did but it still wouldn't
connect.

I also noticed that I needed to change the listening_addresses under
the connection setting in the postgresql.config file. DO I have to do
this? I didn't find the information really clear and there weren't any
examples for me to understand what they mean by 'listen_address' (do
they mean the IP address or the port number???). I tried all '*' but
that didn't work either.

Any ideas?

"mmaclennan" <mmaclennan@gmail.com> writes:

Hi yeah I was doing some reading today and realized that I had to
change the pg_hba.conf file from local host to something else but I
don't wuite understand what I am suppose to be entering for the
CIDR-Address setting. This database will only be accessed from the
network and surrounding computers. The general Ip addresses for the
computers here are 192.168.1.X. Does this mean that the CIDR-Address
should be 192.168.1.0/24? This is what I did but it still wouldn't
connect.

Did you send a SIGHUP to the postmaster after editing the file?

I also noticed that I needed to change the listening_addresses under
the connection setting in the postgresql.config file. DO I have to do
this? I didn't find the information really clear and there weren't any
examples for me to understand what they mean by 'listen_address' (do
they mean the IP address or the port number???). I tried all '*' but
that didn't work either.

'listen_address' should be an IP address. What is it currently set
to?

-Doug

Douglas McNaught <doug@mcnaught.org> writes:

I also noticed that I needed to change the listening_addresses under
the connection setting in the postgresql.config file. DO I have to do
this? I didn't find the information really clear and there weren't any
examples for me to understand what they mean by 'listen_address' (do
they mean the IP address or the port number???). I tried all '*' but
that didn't work either.

'listen_address' should be an IP address. What is it currently set
to?

BTW, I think you need to restart the server after changing
listen_address.

-Doug

Mmaclennan:
Restart Postgresql. If you need help with
this, let us know.

Ezra Taylor

On 16 Feb 2006 21:38:07 -0800, mmaclennan <mmaclennan@gmail.com> wrote:

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

--
Ezra Taylor

I restarted postgresql but that wasn't the problem I didn't have the proper
settings in pg.hba.conf. I added the setting

# host all all 192.168.1.100/32 md5

and that worked. I am running the most recent version of postres and
postgis. I can now connect on the network but I can not open the a DB table
in ArcCatalog 9.0, every time I try Arcatalogue crashed. Originally this
data could be opened with uDig 1.0.5 on the local computer running server
2003 but now uDig can't connect. The only thing that I changed was the
pg_hba.conf file and the postgresql.conf local address to '*' do you know
what I might be missing here?

I realized that I have a lot of issues with the postgres system but I am
relatively new to this. I currently have two projects on the go that will be
using postgres one on Linux Ubuntu and one on Server 2003.

I am beginning to think that postgres doesn't work well with ArcGIS, even
when I do connect I see all the tables and not the shape files. Is there a
way to change this? My users will potentially not have much experience with
connecting to a database so I am wondering how usable this option is. Is it
better to use something commercial or is postgres compatable with arcGIS?

I know these are a lot of questions and any help/advise would be greatly
appreciated.

On 2/18/06, Ezra Taylor <ezra.taylor@gmail.com> wrote:

Mmaclennan:
Restart Postgresql. If you need help with
this, let us know.

Ezra Taylor

On 16 Feb 2006 21:38:07 -0800, mmaclennan <mmaclennan@gmail.com> wrote:

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

--
Ezra Taylor

--
--
Michael MacLennan, H.BA
MES Planning Candidate,
Spatial Environmental Action Research Lab
York University,
Toronto, Ontario
M3J 1P3
(416) 736-2100 ext. 2100