You can also try the importer and it’s rest api, it is much better at async processing of large content.
I wrote some docs here https://docs.geoserver.org/latest/en/user/extensions/importer/rest_examples.html You can use resource api to upload and then process using importer. Jody On Tue, Dec 20, 2022 at 6:18 AM Marlow, Peter via Geoserver-users < geoserver-users@lists.sourceforge.net> wrote: > Hi, > > > > We are using GeoServer 2.18.2 and Postgres 11 with the PostGIS extension > for our website. With small datasets we are not having any issues, but we > are having trouble uploading larger datasets to GeoServer. After making a > request, it hangs for a long time and ends up failing. When the request is > made, the Geoserver web portal also becomes unresponsive and won’t allow > menus to view layers, etc to be opened instead returning a server busy page. > > > > The file sizes that cause the issue tend to be ~15MB+ in size. > > > > Example request: > > > > curl -v -u [un]:[pw] -XPUT -H "Content-type: application/zip" > --data-binary @dataset.zip > http://localhost:8080/geoserver/rest/workspaces/geonode/datastores/[postgres_datastore]/file.shp > > > > To narrow down the problem we tried connecting to a Postgres 9 database > with our existing setup to see if the issue was particular to the version > of Postgres. When that didn’t work we installed vanilla versions Postgres > 11 and GeoServer 2.22.0 locally. This was to test if isolating GeoServer > and Postgres from our existing deployment and using a later version of > Geoserver would help, but the issue persists. > > > > We now believe that there may be something wrong with the way GeoServer is > adding data to Postgres databases. Is there any configuration or setup > we’re missing that might help alleviate this issue? > > > > Kind regards, > > > > *Peter Marlow *| Lead Agile Engineer, Central Government | CGI > > Methuen Park, Chippenham SN14 0GB > > peter.mar...@cgi.com | cgi-group.co.uk > <https://urldefense.proofpoint.com/v2/url?u=https-3A__eur01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Furldefense.proofpoint.com-252Fv2-252Furl-253Fu-253Dhttps-2D3A-5F-5Feur01.safelinks.protection.outlook.com-5F-2D3Furl-2D3Dhttps-2D253A-2D252F-2D252Furldefense.proofpoint.com-2D252Fv2-2D252Furl-2D253Fu-2D253Dhttp-2D2D3A-2D5F-2D5Fcgi-2D2D2Dgroup.co.uk-2D2526d-2D253DDwQFAg-2D2526c-2D253DH50I6Bh8SW87d-2D5FbXfZP-2D5F8g-2D2526r-2D253DYqptHQRpueLxpzhhdrs9rNv0AFhjpvKOJXE5QFg5sec-2D2526m-2D253D-2D5Fgj4eu3TogA5s7Z5B1WbkD7clWbl5NNaUmVrxA-2D5F5Zeg-2D2526s-2D253DTz-2D2DxcS3aG5tkV6h1vHL3UawEi8RBzV8kOEw90UlDdpU-2D2526e-2D253D-2D26data-2D3D02-2D257C01-2D257CJenna.Harris004-2D2540gov.wales-2D257C877c495f30814889579908d803b34f61-2D257Ca2cc36c592804ae78887d06dab89216b-2D257C0-2D257C0-2D257C637263415952110161-2D26sdata-2D3DEe4sImOacbMBaz4O3Ab89Y-2D252BfaxW3GgL4H1GGBmyOa0c-2D253D-2D26reserved-2D3D0-2526d-253DDwMFAw-2526c-253DH50I6Bh8SW87d-5FbXfZP-5F8g-2526r-253DYqptHQRpueLxpzhhdrs9rNv0AFhjpvKOJXE5QFg5sec-2526m-253Ddrz7xRm6eCLkEFCVsBotApQMeCL8KWSA3S2h31qSqM8-2526s-253DJqe-2DNjizHGdWjDjQiSFHkgY-5FcK5Z5crpYPpVxS1VKnA-2526e-253D-26data-3D02-257C01-257CJenna.Harris004-2540gov.wales-257C83f63c4967c749281cbe08d803b3d312-257Ca2cc36c592804ae78887d06dab89216b-257C0-257C0-257C637263418159776608-26sdata-3DrXHcmDMVu2wQTcPw79lSlrOHqeTL1AeJY4-252BnrfEgw2I-253D-26reserved-3D0&d=DwMFAw&c=H50I6Bh8SW87d_bXfZP_8g&r=YqptHQRpueLxpzhhdrs9rNv0AFhjpvKOJXE5QFg5sec&m=LBD2yGv39o8eh4_mmKvmQA40U0MTVXFpTllp2GEizGk&s=sR8k_roT2qxNDgh72mYFIxySjFs4DU6JN3TqtlfQRlU&e=> > _______________________________________________ > 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 > -- -- Jody Garnett
_______________________________________________ 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
