[GeoNode-users] Configuring Remote Database with Geonode

[Joshi, Jigeeshu]

Hi Daniel,

Thank you for your input. Appreciate it !

I have few things to clarify here:
We have just started using Geonode so we do not have much data in Geonode database (on linux server). So, I was thinking  if it is possible to configure the postgresql database on windows server as the main/only Geonode database.
Essentially, Geonode creates two databases ‘geonode’ and ‘geonode_data’. These can be migrated to DB on windows server . Point the Geoserver datastore to this DB.  And make changes in local_settings.py. In my understanding this will enable remote DB on windows server as the default database for Geonode. Please, correct me if I am wrong .

Regards,
Jio

Von: Daniel Victoria [mailto:daniel.victoria at gmail.com]
Gesendet: Dienstag, 17. April 2018 22:00
An: Joshi, Jigeeshu
Cc: geonode-users at lists.osgeo.org
Betreff: Re: [GeoNode-users] Configuring Remote Database with Geonode

Hi Jio,
I don't have documentation ready for this but it's possible to publish data that is hosted in another database. This is how i do it - not sure if it's the most correct way
The steps are:
1) In GeoServer, create a store pointing to the PostGIS database that has the layers
2) In GeoServer, create and publish new layers that are contained inside your new store
3) In your geonode machine, run the command `geonode updatelayers --skip-geonode-registered`. This command will scan your GeoServer for new layers that are not registered in GeoNode and publish them.
4) Fill in metadata / user / access permisison information for each new layer created
Cheers
Daniel

On Tue, Apr 17, 2018 at 5:49 AM Joshi, Jigeeshu <Jigeeshu.Joshi at ils-forschung.de<mailto:Jigeeshu.Joshi at ils-forschung.de>> wrote:

Hi All,

I have a quick question regarding geonode software architecture.

We have installed geonode (standard deployment) on a clean linux server which we have hired and is located outside our organization. However, we already have a postgresql database on Windows server maintained at our organization. Is it possible to have geonode use the postgresql database (on windows server) in our organization so that we do not have to maintain two databases ?  If possible , kindly provide documentation link for further information on configuration steps.

Regards,
Jio
_______________________________________________
geonode-users mailing list
geonode-users at lists.osgeo.org<mailto:geonode-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/geonode-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20180418/f4562485/attachment.html>