[Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

[Hernán De Angelis]

Thank you for your recommendations, Saber. Yes, indexing is important 
and metadata is even more so.

Cheers

Hernán


On 2019-11-20 12:13, Saber Razmjooei wrote:
> Some other things to consider:
> - Indexing (especially spatial indexing) your vectors.
> - Meta-data: trying to capture meta-data as you go. There are some 
> plugins available (Layer Metadata Search: which both captures and 
> allows you to search for your meta-data...happy to help with the set 
> up if you need assistance).
>
> Hope that helps.
>
> Regards
> Saber
>
>
> On Wed, 20 Nov 2019 at 11:08, Hernán De Angelis <dhdeangelis at comhem.se 
> <mailto:dhdeangelis at comhem.se>> wrote:
>
>     Hello Andreas
>
>     Thank you very much for your comment. These are definitely things
>     I did not think about.
>
>     Our people are in two separate buildings (in two separate
>     regions!) but our systems can handle this without problems.
>
>     The editing conflicts seem more serious to me. I guess these could
>     be minimized by encouraging users to save edits more often but, as
>     you write, a proper solution may require proper versioning. But
>     then that may likely push up the costs.
>
>     Good material for thought and a test.
>
>     Thank you again!
>
>     Hernán
>
>
>
>     On 2019-11-20 11:40, Andreas Neumann wrote:
>>
>>     Are those 15 people in the same office/same location or
>>     distributed? If the latter, at how many places are they distributed?
>>
>>     In my experience, using Postgis sources over the internet (not in
>>     the LAN) is way too slow. It will only upset your users. In such
>>     a scenario you would have to set up replication.
>>
>>     Another aspect: avoid editing the same features simultaneously by
>>     different users. Only the last save will stay. QGIS starts an
>>     edit session and will only save at the end of the sesssion, when
>>     you actually save the features. In such a scenario you should
>>     assign certain geographic areas to different users (e.g. user A
>>     edits features in municipality x, and user b in municipality y,
>>     but not x).
>>
>>     Otherwise you will have to deal with handling conflicts. That
>>     would require more complicated table setups with versioning and
>>     conflict detection.
>>
>>     Andreas
>>
>>     On 2019-11-20 11:32, Hernán De Angelis wrote:
>>
>>>     I am evaluating setting up a server running PostgreSQL/PostGIS for use
>>>
>>>>>     as data sharing/collaborating environment for spatial data. The user
>>>>>     group may consist of up to 15 people, mostly using QGIS but one or two
>>>>>     may use other software (non OS). Data is almost exclusively of vector
>>>>>     type. The use is within a single organization.
>>>>>
>>>>>     I understand some people in this list have experience with this kind of
>>>>>     environment and would appreciate if any of you would share any useful
>>>>>     experience, challenges, thought or things to watch out for. I understand
>>>>>     basic management routines are critical (user management, user rights),
>>>>>     as well as a sound backup and update strategy. I also understand that
>>>>>     proper data management procedures have to be in place, like rules for
>>>>>     table creation and eventual deletion, attribute selection, etc. But what
>>>>>     else can go wrong with this kind of setup if not managed properly?
>>>>>     Thoughts and experiences welcome!
>>>>     in our experience the solution is pretty straightforward. The only other
>>>>     challenge I'd add is having good bandwidth, otherwise using PostGIS data
>>>>     can be sluggish.
>>>>     All the best.
>>>
>>>     Excellent point, Paolo! I had not thought about it. Thank you!
>>>
>>>     All the best
>>>
>>>     _______________________________________________
>>>     Qgis-user mailing list
>>>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>>>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
> -- 
> Saber Razmjooei
> www.lutraconsulting.co.uk <http://www.lutraconsulting.co.uk>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191120/dec96a08/attachment-0001.html>