[GeoNode-users] Postgis extension on geonode DB

[Simone Dalmasso]

Right, the best way is still wrap your project into a geonode_project which
is installed system wide as geonode is so it will be integrated and the
geonode_project's INSTALLED_APP will be able to use your own app as well as
geonode.
The geonode_porject settings will add what needed to the geonode settings
and you can leave /etc/geonode/local_settings.py as default.
If you don't want to use the project (but you should :) ) then you have to
make sure that your own app is usable by geonode (in the PYTHONPATH or
installed) and add it to the INSTALLED_APPS list.

No harms in adding postgis to the geondode db, it is just not that
recommended to mix geonode contents with geonode internal data for
maintenance purpose.

Ciao

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

>  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>:
>
>>  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
>
>
>


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