[postgis-users] Errors while creating database from org.geotools.data.postgis

[Rémi Cura]

When you connect to a data base you have to be authentified, so usually you
provide login/password.

If you don't, this means that your are implicitly using your unix login as
your database loggin (a role).

Th mapping (unix - postgres role) is set in server conf file (from memory :
pg_hba.conf)

Maybe in database your role doesn't have the correct rights to perform the
querry.


Cheers,
Rémi-C



2013/12/19 Thomas Schweikle <tschweikle at gmail.com>

> > What is the information connection your
> > software is using to connect to DB where
> > you want to execute commands.
>
> The database is accessed using tcp/ip.
>
> 2013/12/19 Rémi Cura <remi.cura at gmail.com>:
> > What is the information connection your software is using to connect to
> DB
> > where you want to execute commands.
> > Probably wrong role.
> >
> > Cheers,
> > Rémi-C
> >
> >
> > 2013/12/19 Thomas Schweikle <tschweikle at gmail.com>
> >>
> >> Hi!
> >>
> >> I am seeing various errors while a routine tries to create databases.
> >> I'm having trouble interpreting these errors:
> >> --- SNIP
> >> 18:35:34,895 ERROR Dez 18, 2013 6:35:34 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: CREATE TABLE "public"."npp" ("npp_fid" serial PRIMARY
> >> KEY, "the_geom" GEOMETRY, "Name" VARCHAR(256), "Longitude" DOUBLE
> >> PRECISION, "Latitude" DOUBLE PRECISION);
> >> --- SNAP
> >> To me it looks like they are trying to create a database, but without
> >> rights to create the database? Any way to find the user whom is to
> >> create this database?
> >>
> >> --- SNIP
> >> 18:35:35,069 ERROR Dez 18, 2013 6:35:35 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: DELETE FROM GEOMETRY_COLUMNS WHERE f_table_catalog='' AND
> >> f_table_schema = 'public'AND f_table_name = 'npp';
> >> --- SNAP
> >> They want to delete datasets, but fail. Access rights wrong? Wrong
> >> user? Which user was intended? Which user was used? Or -- is this
> >> database not enabled to use postgis??
> >>
> >> --- SNIP
> >> 18:35:35,080 ERROR Dez 18, 2013 6:35:35 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: INSERT INTO GEOMETRY_COLUMNS VALUES
> >> ('','public','npp','the_geom',2,4326,'POINT');
> >>
> >> 18:35:35,089 ERROR Dez 18, 2013 6:35:35 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: ALTER TABLE "public"."npp" ADD CONSTRAINT
> >> enforce_srid_the_geom CHECK (SRID(the_geom) = 4326);
> >>
> >> 18:35:35,097 ERROR Dez 18, 2013 6:35:35 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: ALTER TABLE "public"."npp" ADD CONSTRAINT
> >> enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
> >>
> >> 18:35:35,123 ERROR Dez 18, 2013 6:35:35 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: ALTER TABLE "public"."npp" ADD CONSTRAINT
> >> enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text
> >> OR the_geom IS NULL);
> >>
> >> 18:35:35,133 ERROR Dez 18, 2013 6:35:35 PM
> >> org.geotools.data.postgis.PostgisDataStore createSchema
> >> Information: CREATE INDEX "spatial_npp_the_geom" ON "public"."npp"
> >> USING GIST ("the_geom");
> >> --- SNAP
> >>
> >> Maybe someone 's got an idea how to find out what was going on here!
> >>
> >> --
> >> Thomas
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at lists.osgeo.org
> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
> --
> Thomas
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131219/89e5e4ef/attachment.html>