<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Simone,<br>
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?<br>
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.<br>
Thanks!<br>
:-)<br>
Renata.<br>
<br>
<br>
<br>
Il 12/05/2015 13:22, Simone Dalmasso ha scritto:<br>
</div>
<blockquote
cite="mid:CAAHAC+day4S0GGZ17iDH9w3Ct9mBHu-0Qgm==FJD-d3ef9LW5w@mail.gmail.com"
type="cite">
<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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
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>
</blockquote>
<br>
</body>
</html>