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<http://localhost:8080/geoserver/rest/workspaces/geonode/datastores/%5bpostgres_datastore%5d/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<mailto: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
