[GeoNode-users] Postgis extension on geonode DB

[Simone Dalmasso]

Hi Renata,

I strongly suggest you to use the geonode_project to customize geonode and
add your apps, see https://github.com/GeoNode/geonode-project/tree/2.4.

For your questions:
- here a guide on how to use multiple database on django
https://docs.djangoproject.com/en/1.8/topics/db/multi-db/
- the geonode database already have postgis installed, if you installed
geonode via apt-get you will get two databases, one is called geonode and
the other geonode-data and this one has postgis installed. In any case you
can always install postgis with $ psql -d yourdb -c "CREATE EXTENSION
POSTGIS;"

Hope this helps

2015-05-12 12:21 GMT+02:00 Renata Binotto <rbinotto at arpa.veneto.it>:

>  Hi all,
> we have a DB and a postgresql schema (call it ourSchema) with some layers
> and some tables and we want to edit the tables using Django Admin
> facilities (with server_ipaddress/admin). We wrote in local_settings in
> /etc/geonode the connection strings for this DB (ex: ourDB, in the same
> server with geonode) but after some tests we understood that:
>
> -- creating a new app (with python manage.py startapp ...), a models.py
> with our tables and using python manage.py syncdb --database=ourDB,
> Geonode re-create all django tables + our tables in the *public* schema
> of ourDB ('cause there's no info in local_settings about what schema is
> connected ourDB);
> -- but these new tables in ourDB/public are not seen by
> server_ipaddress/admin, but they are seen only if we create them in the
> schema geonode(=default)/public;
> -- so we thought we could put ourSchema inside geonodeDB or all its
> tables/layers in the geonode/public schema (even if we don't like this
> solution too much...), but ourSchema contains layers and geonodeDB has no
> postgis extensions so we couldn't.
>
> At the end, some desperate questions:
> -- is it possible to connect django server_ipaddress/admin to tables in a
> different DB (putting some connection string in the app directly, for
> example);
> -- is it possible to install postgis extension on geonodeDB?
>
> Thanks!
> Renata.
>
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users
>
>


-- 
Simone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150512/b2669b15/attachment.html>