<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi,</p>
<p>sorry for the late response. Possible yes, but perhaps not
recommendable. I have the DB on a different server (but same hub);
and I find the response times by GeoNode/GeoServer, sometimes
quite slow: because Geoserver has to fech the data from the
Postgis database on the other server to render... and this seems
to be a bottle neck if you have large layers (200-300MB).</p>
<p>cheers,<br>
</p>
<p>stefan<br>
</p>
<br>
<div class="moz-cite-prefix">On 4/18/18 09:21, Dave Kennewell wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAC9xysMBc53j3KZon-nqA81jJCf1D0S1rjxNZ-MqWbQsf5J2Sw@mail.gmail.com">
<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"
moz-do-not-send="true">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" moz-do-not-send="true">[hidden
email]</a>> wrote:<br>
</div>
<blockquote style="border-left:2px solid
#cccccc;padding:0 1em" class="gmail_quote">
<div link="blue" vlink="purple" lang="EN-IN">
<div
class="m_6944978376782420419m_8686007497520881617WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi
Daniel,
</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </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 !</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </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:
</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. </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 .
</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards,</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Jio</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"></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" moz-do-not-send="true">[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
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="DE"><a
href="http:///user/SendEmail.jtp?type=node&node=5361875&i=2"
rel="nofollow noreferrer" link="external"
target="_blank" moz-do-not-send="true">[hidden
email]</a><br>
<b>Betreff:</b> Re: [GeoNode-users]
Configuring Remote Database with Geonode</span></p>
</div>
</div>
<div link="blue" vlink="purple" lang="EN-IN">
<div
class="m_6944978376782420419m_8686007497520881617WordSection1">
<p class="MsoNormal"> </p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"
style="margin-bottom:12.0pt">Hi
Jio,</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</p>
</div>
<p class="MsoNormal">The steps are:</p>
</div>
<p class="MsoNormal">1) In GeoServer,
create a store pointing to the
PostGIS database that has the layers</p>
</div>
<p class="MsoNormal">2) In GeoServer,
create and publish new layers that are
contained inside your new store</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.</p>
</div>
<p class="MsoNormal"
style="margin-bottom:12.0pt">4) Fill in
metadata / user / access permisison
information for each new layer created</p>
</div>
<p class="MsoNormal">Cheers</p>
</div>
<p class="MsoNormal">Daniel</p>
</div>
<p class="MsoNormal"> </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" moz-do-not-send="true">[hidden
email]</a>> wrote:</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></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">Hi
All,</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span></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></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span></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></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd"> </span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">Regards,</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4f81bd">Jio</span></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" moz-do-not-send="true">[hidden
email]</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/geonode-users"
rel="nofollow noreferrer" link="external"
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/geonode-users</a></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" moz-do-not-send="true">[hidden email]</a>
<br>
<a
href="https://lists.osgeo.org/mailman/listinfo/geonode-users"
rel="nofollow noreferrer" link="external"
target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/geonode-users</a><br>
<br>
<br>
<hr size="1" noshade="noshade" 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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">NAML</a> </div>
</blockquote>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
geonode-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/geonode-users">https://lists.osgeo.org/mailman/listinfo/geonode-users</a>
</pre>
</blockquote>
<br>
</body>
</html>