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

[prev in list] [next in list] [prev in thread] [next in thread] 

List: qgis-user
Subject: [Qgis-user] Ang: Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?
From: Hernán <dhdeangelis () comhem ! se>
Date: 2019-11-21 5:19:36
Message-ID: -tntl9l-el653x-hv2isontcwcg2e7e83sioqv066zyq51jactvgnhtqmvn4wvwbhlm89y39tninteey7-447gjhchj7c9b1or6i-1gb9h-9zp0ic-b4ogvz-pm7mgxr8n6f5-4bdz47-lwwurp-o20kd2.1574313576272 () email ! android ! com
[Download RAW message or body]

[Attachment #2 (text/html)]

Hi Jose Mercedes Thank you very much for the detailed description of how you \
implemented your system. You seem to have refined and streamlined things a lot. Must \
be a very neat system to work with! Best regards and thanks \
again! HernÃ¡n <div class="quote" style="line-height: \
1.5"> -------- Ursprungligt meddelande -------- Ã„mne: Re: [Qgis-user] \
Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment? FrÃ¥n: \
Jose Mercedes Venegas Acevedo <jvenegasperu@gmail.com> Till: \
dhdeangelis@comhem.se Kopia: qgis-user <qgis-user@lists.osgeo.org> <blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr"> Good morning What you manifest is precisely the \
work environment that I have assembled You can manage all the permissions to \
the tables and columns directly with postgres as well as the rights of users to be \
able to write or only see in any table Regarding backup copies, I have audit \
tables implemented for all insert update and delete operations for each table. and of \
course a daily backup of the database. Regarding the rules I have direct \
contact with the postgres committers and they are in disuse so I better use triggers \
and store procedures for whatever you need. I eliminated all my rules and converted \
them into functions or triggers at your recommendation. I have been working \
with this environment for years and I have never had a problem right now I am \
migrating from postgres 9.4 to 11.5 I am taking the opportunity to rewrite and \
document some things of the BD and everything in order so go ahead with your project \
I guess you are also enrolled in the list of Postgres I am enrolled in the list of \
postgres but in Spanish. My scenario works so I have about 50 users who \
consult the information have access to the tables as read only have only select \
permission. Then I have a group of editors that are approximately 8 people \
each one is responsible for their layer in QGIS that layer corresponds to a table and \
field geometry in postgres. Various themes are assembled with the set of \
layers that the editors update daily. For some activities there are triggers \
and functions in postgres that automate the drawing and save many clicks, that is, \
for example, drawing lines from clicking on a dot layer, then the lines are drawn \
automatically with the vertices of the other nearby geometries. You can \
practically make QGIS really a CAD (Computer Aided Design) tool if you put the \
business rules into postgraduate functions you save a lot of hours of digitalization \
work. This is what I can tell you about your query I speak Spanish I am \
in Trujillo so excuse the writing I write this with google \
translate Cheers

</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El miÃ©., 20 \
nov. 2019 a las 5:19, HernÃ¡n De Angelis (&lt;<a \
href="mailto:dhdeangelis@comhem.se">dhdeangelis@comhem.se</a>&gt;) \
escribiÃ³:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello QGIS:ers<br> \
<br> I am evaluating setting up a server running PostgreSQL/PostGIS for use <br>
as data sharing/collaborating environment for spatial data. The user <br>
group may consist of up to 15 people, mostly using QGIS but one or two <br>
may use other software (non OS). Data is almost exclusively of vector <br>
type. The use is within a single organization.<br>
<br>
I understand some people in this list have experience with this kind of <br>
environment and would appreciate if any of you would share any useful <br>
experience, challenges, thought or things to watch out for. I understand <br>
basic management routines are critical (user management, user rights), <br>
as well as a sound backup and update strategy. I also understand that <br>
proper data management procedures have to be in place, like rules for <br>
table creation and eventual deletion, attribute selection, etc. But what <br>
else can go wrong with this kind of setup if not managed properly? <br>
Thoughts and experiences welcome!<br>
<br>
Best regards and thanks in advance<br>
<br>
HernÃ¡n<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" \
target="_blank">Qgis-user@lists.osgeo.org</a><br> List info: <a \
href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" \
                target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>

Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" \
rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div><br \
clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><font color="#888888"><div>JosÃ© Mercedes Venegas Acevedo<br>cel Mov RPC \
964185205<br><br><br></div></font></div></div></div></div></div></div></div></div></div></div>
 </blockquote></div>

[Attachment #3 (text/plain)]

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[prev in list] [next in list] [prev in thread] [next in thread] 