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

2011-03-15 Thread 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 :
> 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?

2011-02-28 Thread 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


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

2011-02-28 Thread 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 :
> 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?

2011-02-28 Thread 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