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

[Jean-François Gigand]

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
>
>