You can also use nmap on the machine hosting GeoServer to see if your network configuration permits it to connect.
nmap -p 5432 your.database.server.example.org "closed" means it is likely not listening. "filtered" means it is likely blocked by a firewall. "open" means it is accepting TCP connections. On 16/09/10 14:00, [email protected] wrote: > The hba file is one location, also for some distributions of linux, the > bundled postgres/postgis by default does NOT listen on all network > adapters/interfaces, just localhost. > > So with postgres listening on the correct adapter/interface, and then the > entries in the hba file to allow for your connection, have a shot at that. > > Terry > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Thursday, 16 September 2010 1:29 PM > To: [email protected]; [email protected] > Subject: [ExternalEmail] Re: [Geoserver-users] Connecting to PostGIS from > Geoserver. > > Can you connect to the db from the server that geoserver is installed ? If > not, you need to enable the remote connection by adding a record in > pg_hba.conf file. > > -----Original Message----- > From: skea [mailto:[email protected]] > Sent: Monday, 13 September 2010 6:18 PM > To: [email protected] > Subject: [Geoserver-users] Connecting to PostGIS from Geoserver. > > > I am running Geoserver 2.02.(not locally installed) > I installed PostGIS and postgresql on my laptop,i connect to PostGIS using > the command line tool. I was able to create a database and connect to it and > added tables to it. > > Now i wanted to connect to this database through Geoserver and add the > tables to Geoserver. > When i try, i get an error saying: "Error creating data store, check the > parameters. Error message: Unable to obtain connection: Cannot create > PoolableConnectionFactory (Connection refused. Check that the hostname and > port are correct and that the postmaster is accepting TCP/IP connections.)" > . > I have looked at most links especially > http://workshops.opengeo.org/stack-intro/geoserver.html > http://workshops.opengeo.org/stack-intro/geoserver.html > and > http://demo.cleverelephant.ca/~pramsey/oss-geostack-intro/doc/en/geoserv...). > http://demo.cleverelephant.ca/~pramsey/oss-geostack-intro/doc/en/geoserv...). > > The error i get is described in this page: > http://old.nabble.com/Trouble-connecting-GeoServer-%28Linux%29-to-PostGI... > http://old.nabble.com/Trouble-connecting-GeoServer-%28Linux%29-to-PostGI... > > Is there help anywhere, has any one here gotten some experience in this. -- Ben Caradoc-Davies <[email protected]> Software Engineering Team Leader CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
