Thread: 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.
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.
--
--
Michael MacLennan, H.BA
MES Planning Candidate,
Spatial Environmental Action Research Lab
York University,
Toronto, Ontario
M3J 1P3
(416) 736-2100 ext. 2100
# 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