<div dir="auto"><div>Hi Jio, </div><div dir="auto"><br></div><div dir="auto">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. </div><div dir="auto"><br></div><div dir="auto">Good luck! </div><div dir="auto">Dave<br><br><div class="gmail_quote" dir="auto"><div dir="ltr">On Wed, 18 Apr 2018, 16:13 DanielV [via OSGeo.org], <<a href="mailto:ml%2Bs1560n5361875h40@n6.nabble.com">ml+s1560n5361875h40@n6.nabble.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div>Hi Jio,<br><br></div>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. <br><br></div>Cheers<br></div>Daniel<br></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Apr 18, 2018 at 5:01 AM Joshi, Jigeeshu <<a href="http:///user/SendEmail.jtp?type=node&node=5361875&i=0" rel="nofollow noreferrer" link="external" target="_blank">[hidden email]</a>> wrote:<br></div><blockquote style="border-left:2px solid #cccccc;padding:0 1em" class="gmail_quote">
<div lang="EN-IN" link="blue" vlink="purple">
<div class="m_6944978376782420419m_8686007497520881617WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi Daniel,
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thank you for your input. Appreciate it !<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I have few things to clarify here:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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 .
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Jio<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Daniel Victoria [mailto:<a href="http:///user/SendEmail.jtp?type=node&node=5361875&i=1" rel="nofollow noreferrer" link="external" target="_blank">[hidden email]</a>]
<br>
<b>Gesendet:</b> Dienstag, 17. April 2018 22:00<br>
<b>An:</b> Joshi, Jigeeshu<br>
<b>Cc:</b> geonod</span><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><a href="http:///user/SendEmail.jtp?type=node&node=5361875&i=2" rel="nofollow noreferrer" link="external" target="_blank">[hidden email]</a><br>
<b>Betreff:</b> Re: [GeoNode-users] Configuring Remote Database with Geonode<u></u><u></u></span></p></div></div><div lang="EN-IN" link="blue" vlink="purple"><div class="m_6944978376782420419m_8686007497520881617WordSection1">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Jio,<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">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<u></u><u></u></p>
</div>
<p class="MsoNormal">The steps are:<u></u><u></u></p>
</div>
<p class="MsoNormal">1) In GeoServer, create a store pointing to the PostGIS database that has the layers<u></u><u></u></p>
</div>
<p class="MsoNormal">2) In GeoServer, create and publish new layers that are contained inside your new store<u></u><u></u></p>
</div>
<p class="MsoNormal">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.<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">4) Fill in metadata / user / access permisison information for each new layer created<u></u><u></u></p>
</div>
<p class="MsoNormal">Cheers<u></u><u></u></p>
</div>
<p class="MsoNormal">Daniel<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Tue, Apr 17, 2018 at 5:49 AM Joshi, Jigeeshu <<a href="http:///user/SendEmail.jtp?type=node&node=5361875&i=3" rel="nofollow noreferrer" link="external" target="_blank">[hidden email]</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-left:2px solid #cccccc;padding:0 1em">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">Hi All,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">I have a quick question regarding geonode software architecture. </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">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.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">Regards,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">Jio</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
geonode-users mailing list<br>
<a href="http:///user/SendEmail.jtp?type=node&node=5361875&i=4" rel="nofollow noreferrer" link="external" target="_blank">[hidden email]</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-users" rel="nofollow noreferrer" link="external" target="_blank">https://lists.osgeo.org/mailman/listinfo/geonode-users</a><u></u><u></u></p>
</blockquote>
</div>
</div></div></blockquote></div>
<br>_______________________________________________
<br>geonode-users mailing list
<br><a href="http:///user/SendEmail.jtp?type=node&node=5361875&i=5" rel="nofollow noreferrer" link="external" target="_blank">[hidden email]</a>
<br><a href="https://lists.osgeo.org/mailman/listinfo/geonode-users" rel="nofollow noreferrer" link="external" target="_blank">https://lists.osgeo.org/mailman/listinfo/geonode-users</a><br>
<br>
<br>
<hr noshade size="1" color="#cccccc">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Configuring-Remote-Database-with-Geonode-tp5361694p5361875.html" target="_blank" rel="noreferrer">http://osgeo-org.1560.x6.nabble.com/Configuring-Remote-Database-with-Geonode-tp5361694p5361875.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from GeoNode users, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5185389&code=ZGF2ZWtlbm5ld2VsbEBnbWFpbC5jb218NTE4NTM4OXwtOTI1NjEyMTk0" target="_blank" rel="noreferrer">click here</a>.<br>
<a href="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" rel="nofollow noreferrer" style="font:9px serif" target="_blank">NAML</a>
</div></blockquote></div></div></div>