[GeoNode-users] Configuring Remote Database with Geonode

[Dave Kennewell]

Hi Jio,

Yes, the method you describe should work and enable you to run geonode on a
different server to your databases. Many instances are setup this way.

Good luck!
Dave

On Wed, 18 Apr 2018, 16:13 DanielV [via OSGeo.org], <
ml+s1560n5361875h40 at n6.nabble.com> wrote:

> Hi Jio,
>
> I'm not sure about that. Like you, I'm just a user so I don't know if it's
> possible to move the database to some other host.
>
> Cheers
> Daniel
>
> On Wed, Apr 18, 2018 at 5:01 AM Joshi, Jigeeshu <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=5361875&i=0>> wrote:
>
>> 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:[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=5361875&i=1>]
>> *Gesendet:* Dienstag, 17. April 2018 22:00
>> *An:* Joshi, Jigeeshu
>> *Cc:* geonod[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=5361875&i=2>
>> *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 <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=5361875&i=3>> 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
>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=5361875&i=4>
>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>
>>
> _______________________________________________
> geonode-users mailing list
> [hidden email] <http:///user/SendEmail.jtp?type=node&node=5361875&i=5>
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://osgeo-org.1560.x6.nabble.com/Configuring-Remote-Database-with-Geonode-tp5361694p5361875.html
> To unsubscribe from GeoNode users, click here
> <http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5185389&code=ZGF2ZWtlbm5ld2VsbEBnbWFpbC5jb218NTE4NTM4OXwtOTI1NjEyMTk0>
> .
> NAML
> <http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20180418/46a6e872/attachment.html>