<div dir="ltr">Hi Renata,<div><br></div><div>I strongly suggest you to use the geonode_project to customize geonode and add your apps, see <a href="https://github.com/GeoNode/geonode-project/tree/2.4">https://github.com/GeoNode/geonode-project/tree/2.4</a>.</div><div><br></div><div>For your questions:</div><div>- here a guide on how to use multiple database on django <a href="https://docs.djangoproject.com/en/1.8/topics/db/multi-db/">https://docs.djangoproject.com/en/1.8/topics/db/multi-db/</a></div><div>- 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;"</div><div><br></div><div>Hope this helps</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-05-12 12:21 GMT+02:00 Renata Binotto <span dir="ltr"><<a href="mailto:rbinotto@arpa.veneto.it" target="_blank">rbinotto@arpa.veneto.it</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi all,<br>
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: <br>
<br>
-- creating a new app (with python manage.py startapp ...), a
models.py with our tables and using python manage.py syncdb
--database=ourDB,<br>
Geonode re-create all django tables + our tables in the <u>public</u>
schema of ourDB ('cause there's no info in local_settings about what
schema is connected ourDB);<br>
-- 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;<br>
-- 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.<br>
<br>
At the end, some desperate questions:<br>
-- 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);<br>
-- is it possible to install postgis extension on geonodeDB? <br>
<br>
Thanks!<span class="HOEnZb"><font color="#888888"><br>
Renata.<br>
<br>
</font></span></div>
<br>_______________________________________________<br>
geonode-users mailing list<br>
<a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Simone </div>
</div>