Hi Anton,
Please, keep the conversation on the mailing list so others can help you
or benefit from our conversation.
I don't use gsconfig, so I'm not able to help you with it. However, once
you set up your PostGIS JNDI datastore, it's just another datastore and
I wildly guess that gsconfig will work happily with it.
In my opinion setting up JNDI manually is just a small effort for a very
high reward.
Cheers,
Peter
On 28. 9. 2016 10:40, Anton Lundkvist wrote:
Ok thanks!
I'm relying heavily on gsconfig.py
https://github.com/boundlessgeo/gsconfig for publishing my tables. I
haven't found any info on if it is possible to use JNDI with gsconfig.
Does anyone know?
regards,
anton
2016-09-28 9:15 GMT+02:00 Peter Kovac <peter.ko...@microstep-mis.com
<mailto:peter.ko...@microstep-mis.com>>:
Hi Anton,
If you are using Apache Tomcat or another container I recommend
using JNDI connection pooling. That way you have 1 connection pool
shared among all of your layers and you can manage it easily. I
observed significant performance gains when switching from
"PostGIS" to "PostGIS (JNDI)" type of store (database connections
don't have to be recreated with each request and it saves a lot of
time). It works with ImageMosaic datastores with custom dimensions
too.
http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
<http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html>
Cheers,
Peter
On 28. 9. 2016 8:57, Anton Lundkvist wrote:
Hi GeoServer Users:
I'm using GeoServer for serving vector data (from PostGis).
Keeping the number of stores down e.g. many layers per store
reduces the number of connections to PostGis. This is desirable
as I have hundreds of tables that are published through GeoServer.
Is there a recommended limit for how many layers / resources I
should handle with one store?
Regards,
Anton Lundkvist
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://lists.sourceforge.net/lists/listinfo/geoserver-users>
--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>
--
-------------------------------------------------------------------
Anton Lundkvist
Malmö
Tel: 0046 768 847 703
--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
