[QGIS-Developer] PostgreSQL connection - more than one DB host

[Régis Haubourg]

Interesting, if this works, that could be awesome for having one project
for multiple working sites or on the field use cases. (I just discover it
is now possible to run postgresql on Android last week)
Régis

Le mar. 21 mai 2019 à 13:02, Tim Sutton <tim at kartoza.com> a écrit :

> Did you try it using a service file (haven’t tested myself)….would be
> interesting to hear how you got it working….
>
> Regards
>
> Tim
>
> On 21 May 2019, at 08:47, Andreas Neumann <a.neumann at carto.net> wrote:
>
> Hi,
>
> According to the libpq documentation it is possible to specify more than
> one host for PG connections.
>
> See https://www.postgresql.org/docs/current/libpq-connect.html  -->
> section 34.1.1.2. Connection URIs
>
> -----------
>
> It is possible to specify multiple host components, each with an optional
> port component, in a single URI. A URI of the form
> postgresql://host1:port1,host2:port2,host3:port3/ is equivalent to a
> connection string of the form host=host1,host2,host3
> port=port1,port2,port3. Each host will be tried in turn until a
> connection is successfully established.
>
> -------------
>
> Is this option to specify more than one host supported by QGIS and if yes,
> how? It would only make sense for read-only connections, I think.
>
> Thanks,
> Andreas
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> —
>
>
>
>
>
>
>
>
> *Tim Sutton*
>
> *Co-founder:* Kartoza
> *Ex Project chair:* QGIS.org
>
> Visit http://kartoza.com to find out about open source:
>
> Desktop GIS programming services
> Geospatial web development
> GIS Training
> Consulting Services
>
> *Skype*: timlinux
> *IRC:* timlinux on #qgis at freenode.net
>
> I'd love to connect. Here's my calendar link
> <https://calendly.com/timlinux> to make finding time easy.
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190521/be4e1f03/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KartozaNewLogoThumbnail.jpg
Type: image/jpeg
Size: 6122 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190521/be4e1f03/attachment-0001.jpg>