Re: [postgis-users] How to set up a db for editing in postgis?
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 : > 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 > An: PostGIS Users Discussion > 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 : >> 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@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to set up a db for editing in postgis?
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 An: PostGIS Users Discussion 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 : > 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
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 : > 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] How to set up a db for editing in postgis?
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users