[Qgis-user] Multi users environment: From geopackage to a database?

[Andreas Neumann]

Hi Bruno,

Unfortunately it is a known issue that Geopackages and QGIS are bad at 
handling simultaneous write and even read requests and developers are 
working on finding solutions (hopefully soon). In single user scenarios 
Geopackages are fine. But Multiuser must be avoided, even for reading 
only, unfortunately.

As to PostgreSQL vs. Postgis: Postgis is the spatial extension of 
PostgreSQL. If you need geometries (which I assume) than you will need 
Postgis.

Andreas

Am 06.05.20 um 08:58 schrieb brunos at mailbox.org:
>
> Hi
>
> In my company we are five people who sometimes work with GIS, and we 
> are moving from ArcGIS to QGIS (how cool is QGIS and SLYR!) and in 
> this context from ESRI file geodatabase to geopackage. Today we run 
> into serious issues when two people worked with the same geopackage. I 
> was aware, that it is dangerous and unwise to edit the same geopackage 
> from two different computers at the same time. But I did not expect 
> both QGIS applications to crash immediately and the geopackage to get 
> corrupted. I hoped to get a warning or simply not be able to enter 
> edit mode (We later found out, that the corrupted geopackage could be 
> recoveredby by adding a new table, this somehow fixed it. Whew!).
>
> Worse, I found that the same thing happens, when I open a QGIS project 
> with a layer from a geopackage for display only (no edit mode), which 
> is being edited by an other user on an other computer. Again, both 
> QGIS application crashed immediately with data loss. Again, the 
> non-responsive QGIS tasks could not be killed by windows taskmanager, 
> only by restarting of the computers.
>
> We are using QGIS 3.12.2 on Windows 10. The Geopackages are located on 
> a samba network share.
>
> My questions:
>
> 1. Is this setup that bad? Do you experience the same fatal 
> consequences if someone loads a layer from a geopackage which is being 
> edited by someone else? Is there something I do wrong or I that can do 
> to improve the situation?
>
> 2. I realize, that we should probably move from geopackage to a 
> database. Do we need PostGIS or can we use PostgreSQL? We don't need 
> more functinality than a geopackage offers (exept multi user read/edit 
> possibility and stability).
>
> Many thanks for some hints that put me in the right direction!
>
> Bruno
>
>
> _______________________________________________
> Qgis-user mailing list
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200506/7b197c05/attachment.html>