[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [udig-devel] not able to connect to PostGIS
|
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