[Featureserver] connecting to PostGIS - WinXP psycopg2 install question

[Sacha Black]

On Thu, Aug 28, 2008 at 11:03 PM, Andrew de Klerk
<andrew.deklerk at gmail.com> wrote:

> I am also using featureserver with xp, and have installed the following
> components:
>
> psycopg2-2.0.7.win32-py2.5-pg8.3.1-release.exe
> (http://www.stickpeople.com/projects/python/win-psycopg/#Version2 )
>
> GDAL-1.5.2.win32-py2.5.exe (http://pypi.python.org/pypi/GDAL/ - download
> link is right at the bottom)
>

thanks so much for those links - i really struggled with the psycopg2
install process so the link for an installer is a huge help.

> I have my features displaying from postgis perfectly through openlayers. The
> only thing that I have not got working is writing edits back to the
> database. I think this is because I need to build and add
> simplejson-1.9.2.tar.gz to my python ( but just guessing!). Perhaps someone
> else can offer some insight

i might be wrong but i think simplejson is already included with the
featureserver download (?) - because i don't think the demo will work
with out it. The readme here :
http://www.featureserver.org/doc/Readme.html , indicates that  "the
end goal is to extract the simplejson directory from the distribution
and put it in the root of your FeatureServer install." so that seems
fairly simple - but maybe i missed something. Did you edit
featureserver.cfg to include a link to your PostGIS layer? the text
should look something like this:

[scribblePG]
type=PostGIS
dsn=host=localhost dbname=mygisdb user=myuser password=mypassword
layer=layername
fid=gid
geometry=the_geom
srid=4326

>
> Hope that helps
> Andrew
>

it really does - now I will experiment with the connection and see
what i can do....

thanks again

- Sacha