topic Postgresql configuration setting in Geodatabase Questions

Postgresql configuration setting

yockee — Tue, 12 Nov 2024 05:57:27 GMT

I am about to embark on a survey project using Field Map. The data are stored on postgresql 16 using Enterprise 11.0.

What settings / configurations should I consider ? What values do I set into ?

The survey will involve:

- 70 surveyor using mobile phone accessing Field Map. Probably will have 20-30 concurrrent insert to database.

- point Feature Class that contain data to be inserted. There are around 30 cloumns to be filled in. This will contain some photos too, small size around 10 - 50 kb. Editing attributes will happen here, including insert photos (small size, 10-50kb).

- Polygon Feature Class that contain photos and 4 attributes only for confirmatory process. This will be used as guidance only, no editing here.

- QC processes using arcgis pro. this will access geodatabase directly and accessing survey data via feature service. This will compare the newly inserted data and the old data. There will be around 5 - 10 people doing the QC.

Here is the current configuration:

Re: Postgresql configuration setting

VinceAngelo — Tue, 12 Nov 2024 15:01:23 GMT

Your first step should be to search on "arcgis postgresql requirements" and look to see if the database is supported (PG 16 isn't supported at 11.4.0, much less 11.0).

I haven't tuned an RDBMS in at least a decade, possibly two, so I doubt this is a priority.

- V

Re: Postgresql configuration setting

yockee — Wed, 13 Nov 2024 01:23:46 GMT

Hi @VinceAngelo , here is what the database version says : PostgreSQL 16.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20231218 (Red Hat 11.4.1-3), 64-bit . I am running Arcgis enterprise 11.0.

Re: Postgresql configuration setting

VinceAngelo — Wed, 13 Nov 2024 06:52:03 GMT

That's not a supported combination. It might work, or it might spawn a small black hole which consumes the data center. I wouldn't hold my breath for either of these outcomes for ArcGIS 11.0.

- V

Re: Postgresql configuration setting

yockee — Fri, 15 Nov 2024 07:05:49 GMT

How about the memory and all the settings, regardless the versions difference ? Please help to poin to any articles.. thank you. @VinceAngelo