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

[Hernán De Angelis]

Interesting point, Luigi. Thank you!

Hernán


On 2019-11-20 12:58, Luigi Pirelli wrote:
> this is not an issue, Postgres support many auth systems most of them 
> paired with the authentication system implemented in QGIS. Other 
> problem is how to share (auth.db) credentials or security setting 
> among different users.
>
> Luigi Pirelli
>
> **************************************************************************************************
> * LinkedIn: https://www.linkedin.com/in/luigipirelli
> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
> * GitHub: https://github.com/luipir
> * Book: Mastering QGIS3 - 3rd Edition 
> <https://www.packtpub.com/eu/application-development/mastering-geospatial-development-qgis-3x-third-edition>
> * Hire a team: http://www.qcooperative.net
> **************************************************************************************************
>
>
> On Wed, 20 Nov 2019 at 11:53, Jan-Eric Oskarsson <jan-eric at kregis.se 
> <mailto:jan-eric at kregis.se>> wrote:
>
>     Hi Hernán!
>     Maybe this comment is redundant but you have to set up a strong
>     security to prevent hackers to hack your database and steal your
>     data and cause damage.
>     I hope uthat you already have thought about this issu!
>
>     Kind Regards
>     Jan-Eric
>
>     -----Ursprungligt meddelande-----
>     Från: Qgis-user <qgis-user-bounces at lists.osgeo.org
>     <mailto:qgis-user-bounces at lists.osgeo.org>> För Hernán De Angelis
>     Skickat: den 20 november 2019 11:10
>     Till: qgis-user <qgis-user at lists.osgeo.org
>     <mailto:qgis-user at lists.osgeo.org>>
>     Ämne: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a
>     multiuser environment?
>
>     Hello QGIS:ers
>
>     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!
>
>     Best regards and thanks in advance
>
>     Hernán
>
>
>
>
>
>     _______________________________________________
>     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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191120/a04ea3f7/attachment.html>