[Qgis-user] sharing qgis project networking

Saulteau Don sault.don at gmail.com
Mon Mar 9 08:21:02 PDT 2020


Hey Cecilia,

when connecting over LAN, by default, the host is your computer name, and
the port is 5432 if it hadn't been changed in the postgresql.conf and your
firewall has to have that port open.

If users are connecting via WAN, then your router also has to forward that
port to your machine and users need to enter your WAN IP as the host (could
also use a DNS for external users if you don't have a static IP).

There's a little bit of config required to get it working right and also
consider using SSL to encrypt user logins over the WAN.

For users, they should ideally have their own login and password because
maybe you don't want everyone making permanent changes to the project in
the database.

There's a postgresql mailing list for help and lots of online resources for
configuring postgresql.

On Mon., Mar. 9, 2020, 06:20 Maria Cecilia Zalazar, <
zalazarmariacecilia at gmail.com> wrote:

> Dear Donovan. Thanks for your answer.
> A postgresql database to host the project could be a great idea to share
> it.
> If the database is hosted in my local-computer, remote users can access
> just creating a new connection. But, what should the host and port be (in
> remote connection)?
> Is just the name, the user and password owners of the database?
> Regards.
>
> [image: image.png]
>
>
>
>
> El sáb., 7 de mar. de 2020 a la(s) 13:40, Saulteau Don (
> sault.don at gmail.com) escribió:
>
>> Can you explain the workflow a little bit?
>>
>> For example, you can have a postgresql database to host the project[1]
>> that other users can access over the network...
>>
>> Permissions for changing the master project could be controlled by the
>> database and maybe even setup triggers to track any changes to the project.
>>
>> [1]
>> https://www.bostongis.com/blog/index.php?/archives/271-New-in-QGIS-3.2-Save-Project-to-PostgreSQL.html
>>
>>
>>
>> SaultDon (Donovan)
>>
>> On Sat., Mar. 7, 2020, 08:47 Maria Cecilia Zalazar, <
>> zalazarmariacecilia at gmail.com> wrote:
>>
>>> Dear, is there any way to carry out a QGIS project as a form of
>>> networking among collaborators?
>>> Thanks you! regards
>>> _______________________________________________
>>> 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
>>
>> _______________________________________________
>> 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/20200309/2b344199/attachment.html>


More information about the Qgis-user mailing list