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

[Jean-François Gigand]

Hi,

You would get the answer by inspecting the logs. Try to find if
geoserver can log its PostGIS queries, otherwise, PostgreSQL can be
configured to log all queries.
If it is a database permission problem, you will see the error with an
explanation.

Good luck,

Jean-François


2011/3/1 Robert Buckley <robertdbuckley at yahoo.com>:
> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>