[pgpool-general: 8464] Read only session when connecting from QGIS to a master/slave cluster

Giuseppe Sacco giuseppe at sguazz.it
Thu Oct 20 21:17:41 JST 2022


Hello,
I recently configured pgpool for accessing a master/slave cluster with
streaming replication. I suppose that all clients are normally connected to
the slave until they issue a statement that modify data. Using psql we have
no problem in connecting to pgpool and it seems it balance the requests as
expected.

But, when using QGIS, sometimes the icon that allow to modify the data is
grayed. I think it might be because the connection is marked as read only,
but I am not sure about that.

Anyone has similar experiences?

Thank you,
Giuseppe




More information about the pgpool-general mailing list