GeoServer connects to PostGIS directly, either through JDBC props or JNDI. The latter gives you more control over connection pooling using standard Java Servlet technology.
The original question is a classic. Yes, you can write a bunch of code to query PostGIS directly and provide a GeoJSON web service for your apps. For really simple use cases, and when you have really no other need for a Map Server like GeoServer, then that might make sense. But as your solution grows, you will eventually be re-inventing the wheel one piece at a time, when it comes to things like: a proper Query API, resource management, support for 3rd party clients, etc. The GeoServer WFS is stable, robust, and standards compliant. Oh yeah, and free! Jason Newmoyer Newmoyer Geospatial Solutions 843.606.0424 ja...@newmoyergeospatial.com On Wed, Jan 29, 2020 at 11:14 AM Rahkonen Jukka (MML) < jukka.rahko...@maanmittauslaitos.fi> wrote: > Hi, > > > > Fundamental question: Is it possible to make Geoserver to connect the > PostGIS database directly, or is that database in some external location so > that you must use either files or some service for transporting the data? > Or do you have a master database that keeps the native data and another > database that you are using with Geoserver? > > > > -Jukka Rahkonen- > > > > *Lähettäjä:* Vera Green <vera.green...@gmail.com> > *Lähetetty:* keskiviikko 29. tammikuuta 2020 17.55 > *Vastaanottaja:* Ian Turton <ijtur...@gmail.com> > *Kopio:* geoserver-users <geoserver-users@lists.sourceforge.net> > *Aihe:* Re: [Geoserver-users] Import geojson from Postgis to GeoServer > > > > This makes me wonder if it's more efficient to export geojason from wfs or > directly from PG. Currently I'm going to the database for this in my web > applications. > > Vera > > > > On Wed., Jan. 29, 2020, 3:58 a.m. Ian Turton, <ijtur...@gmail.com> wrote: > > The obvious way to do this is to skip the geojson and just add the PostGIS > tables as new layers, you can export them from GeoServer as GeoJSON using > WFS if you want. > > > > Ian > > > > On Wed, 29 Jan 2020 at 09:48, Vitor Fonseca <vfonse...@gmail.com> wrote: > > > > Hi, > > > > Confusing questions. Please elaborate more on what you want to do... > > > > > > Samann Long <longsaman...@kit.edu.kh> escreveu no dia terça, 28/01/2020 > à(s) 06:12: > > Hello, I am having some troubles with the rest API of importing geojson > from Postgres PostGIS database to Geoserver to create layer and register to > WFS services. > Are there any ways we can do it? > > Thank you > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > -- > > [image: Lähettäjä poisti kuvan.] > > www.vfonsecaz.pt > > > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > -- > > Ian Turton > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
