Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [udig-devel] not able to connect to PostGIS
The strange bit of behavior is a result of how the wizard/driver tries to populate the "list-o-databases" drop down. Behind the scenes, it attempts to connect to the "template1" database and query the system tables for a list of databases. But in a privilege- constrained world (like our open database, or really any managed system) access to template1 is not blanket allowed to all user accounts. So the attempt to populate the drop down fails with an access denied. But that doesn't mean that you can't still connect to databases you know about and have privileges for (like demo-bc).
WRT the driver, the line protocol did not change between 7.4 and 8.0 so the old driver works on the new database. Regardless, it would be good for uDig to ship with the new driver, since backwards compatibility is guaranteed more than forward over the long run. 

Paul

On 27-Aug-05, at 11:10 AM, William Kyngesburye wrote:
Ah. I coulda swore I used a hyphen - I remember noticing that and backing up to correct it. Oh well, it works.
I also noticed that 'strange behaviour'. That's probably what made me think it wasn't working the first time (in the RC versions) - it failed after the password, so I didn't try entering a DB name.
I then tried the original postgres 7.4 jar, and demo-bc still works. I wonder what I'm doing with my postgis setup that it doesn't work with the older driver? 

Well, here's the postgres driver download link:

<http://jdbc.postgresql.org/download.html>


On Aug 27, 2005, at 10:36 AM, Jesse Eichar wrote:



Thanks Paul, you are right.

I've just noticed a strange bit of behaviour.  You get an error after
you enter the password(because not all dbs are public) but when you put 
demo-bc in the database part all goes well.

Jesse

On Sat, 2005-08-27 at 07:37 -0700, Paul Ramsey wrote:



Jesse said "demo-bc" and you said "demo_bc"... are you using the
right database name?

On Aug 26, 2005, at 9:43 PM, William Kyngesburye wrote:




The postgres library is supposed to be backwards compatible, I
believe.  Somewhere in the readme or documentation, I think, or on
the download page.

I still can't connect to the refractions postgres, same as before:

org.geotools.data.DataSourceException: Connection
failed:org.postgresql.util.PSQLException: Connection rejected:
FATAL: no pg_hba.conf entry for host "24.159.243.19", user
"postgres", database "demo_bc".

that postgres configuration problem to let any IP address connect.
(that host IP is my current home IP, I've also tried from work)

But, how does that verify backwards compatibility, if refractions
uses pgsql 8.0.3 also?  Or were those 2 separate questions?

On Aug 26, 2005, at 6:35 PM, Jesse Eichar wrote:





So... do you know if it is backward compatible?  Does it work with
the

www.refractions.net
postgres/postgres
demo-bc
public

database?  That one is postgres 8.0.3 postgis 1.0.1.
Jesse



William Kyngesburye wrote:






Woohoo!  I found the jdbc.postgresql.org site and downloaded the
jdbc3 driver for postgres 8.  I replaced the
postgresql-74.213.jar in  the udig plugins folder.  Success in
connecting to my postgres 8/ postgis data!


On Aug 24, 2005, at 10:23 AM, William Kyngesburye wrote:






I reported this also in the RC stages for Mac OS X.  Can't
connect  to pgsql.  And no, your refractions postgres is still
not public.

FWIW, I'm trying to connect to postgres 8.0.3/postgid 1.0.3.  I
noticed in the udig plugins that the postgres library is for
postgres 7.4.






-----
William Kyngesburye <kyngchaos@xxxxxxxxxxxxx>
http://www.kyngchaos.com/

Theory of the Universe

There is a theory which states that if ever anyone discovers
exactly what the universe is for and why it is here, it will
instantly disappear and be replaced by something even more
bizarrely inexplicable.  There is another theory which states that
this has already happened.

-Hitchhiker's Guide to the Galaxy 2nd season intro
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel





_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel




_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel




-----
William Kyngesburye <kyngchaos@xxxxxxxxxxxxx>
http://www.kyngchaos.com/

"Time is an illusion - lunchtime doubly so."

- Ford Prefect
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel

Back to the top