[QGIS-Developer] QGIS + Cluster PostgreSQL

[Régis Haubourg]

Hi
I have never heard of such a setup and QGIS will not support this our of
the box. You might split qgis project for editors wired on 5432 and read
only projects on 5433. But nothing automatic to switch port when entering
edit mode.

Side question, I don't understand why you would use different ports.
I've used pgpool for replication / load balancing and fail over for years
and it works well. Even if it is often overkill and the reason for more
issues than a single node correctly sized.

I learnt that the simpler the better. And postgres is extremely forgiving,
so you may sometimes question if a cluster is really needed.
Best regards
Régis

Le jeu. 22 avr. 2021 à 20:08, Rebassa Oliver, Joan <
joan.rebassa at imi.palma.cat> a écrit :

> Buenas tardes:
>
> Tenemos configurado un cluster de base de datos de PostgreSQL de forma que
> el nodo maestro de este cluster es el que permite las operaciones de
> escritura en base de datos a través del puerto 5432 y el resto de nodos que
> forman el cluster son nodos esclavos a los que se replican los cambios que
> se han hecho en el maestro y asumen las operaciones de lectura en base de
> datos por el puerto 5433, las aplicaciones que han de acceder a las bases
> de datos deben poder tener definidos dos datasources: uno para las
> operaciones de escritura por el puerto 5432 y otro para lectura por el
> puerto 5433, queremos saber si Qgis soporta esta configuración.
>
> Gracias.
>
> Good afternoon:
>
> We have configured a PostgreSQL database cluster so that the master node
> of this cluster is the one that allows database write operations through
> port 5432 and the rest of the nodes are slave nodes, the changes that have
> been made in the master are replicated to the slave nodes and they assume
> the database read operations through port 5433, the applications that have
> to access the databases must have two datasources configured: one for
> database write operations (port 5432) and another for read operartions
> (port 5433), we want to know if Qgis supports this configuration.
>
> Thanks.
>
> _______________________________________________
> 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/20210422/10be9944/attachment.html>