[GeoNode-users] Postgis extension on geonode DB

[Renata Binotto]

Hi Simone,
thanks for the answer but... of course we still have a project and our 
app is inside that project, but we have geonode 2.4 and local_settings 
file is only in etc/geonode not in the project dir. So what can we do?
And yes, geonode_data (AKA datastore) have postgis, but django 
ourserver/admin uses tables in geonode/public not in 
geonode_data/public, so if there are no contraindications to install 
postgis extension on geonode we could do it, but we wanna be sure of this.
Thanks!
:-)
Renata.



Il 12/05/2015 13:22, Simone Dalmasso ha scritto:
> 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 
> <mailto: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 <mailto: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/04a1eb0e/attachment.html>