[postgis-users] How to set up a db for editing in postgis?

[Robert Buckley]

Hi,

Thanks for the reply.

I am aware that I need to set up the spatial_re and geometry columns in order to 
store spatial information.
My question was set in the context of specifically trying to edit the geometry.

I have set up a postgresql database with postgis and I can import a shapefile 
into it.
For some reason though I cannot edit the data through wfs-t and I am wondering 
if it to do with permissions/restrictions etc. If I try to edit the shapefile 
directly through geoserver it works ok.

which permissions and rights should be adjusted to enable editing in the 
database?

yours,

Robert





________________________________
Von: Jean-François Gigand <jean-francois at gigand.fr>
An: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Gesendet: Montag, den 28. Februar 2011, 19:24:30 Uhr
Betreff: Re: [postgis-users] How to set up a db for editing in postgis?

Hi,

To use a PG database with PostGIS, it needs the "geometry_columns" and
"spatial_ref_sys" tables, and a set of PostGIS functions.
To set these up, you need to run the SQL files :
/usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
/usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql

(the path may vary, if your PG version is different - these are those
of my Debian install).
You need to run these SQL files on your database, as an administrator user.

JF


2011/2/28 Robert Buckley <robertdbuckley at yahoo.com>:
> Hi,
>
> I have been trying to edit with a postgis databank for ages now and can´t
> seem to get it working.
>
> I have geoserver setup in tomcat6 on ubuntu 10.04.
> I have postgres8.4 running with postgis.
> I can connect to postgis through pgadmin
> I have set up an editing web interface with geoext/openlayers
>
> I have tried editing a geoserver layer from a shapefile and it works ok!!!
> I had to play with the permissions and found that I could only edit when the
> file permissions were 0777
>
> To edit in postgis I first created a db in postgis called "zgb"  the owner
> is my postgresql user"geoadmin1"
> The tables in postgis give all privilages to public
> In geoserver the files are owned by "tomcat6" except "www" which is owned by
> "geoadmin1" - this is so that I can´t edit the .js and.html in winscp
>
> I am really confused as to how to set permissions to be able to edit a
> postgisdb. How should the privalages be set to be able to edit geometries?
>
> If it turns ot that this is not really an issue, what else could be
> restricting the editing ability of my app?
>
> What should I generally watch out for to be able to edit postgis?
>
> thanks for any help,
>
> Robert
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110301/d57cef28/attachment.html>