[GeoNode-users] Configuring Remote Database with Geonode

[Stefan Steiniger]

Hi,

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).

cheers,

stefan


On 4/18/18 09:21, Dave Kennewell wrote:
> 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 
> <mailto:ml%2Bs1560n5361875h40 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>
>
>
>
>
> _______________________________________________
> geonode-users mailing list
> 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/20180419/afb34ab0/attachment.html>