[Qgis-user] Problem connecting to PostGIS in QGIS 3.10

[Alessandro Pasotti]

On Mon, Dec 2, 2019 at 6:05 PM Cliff Patterson <cpatterson at psdrcs.com>
wrote:

> While testing QGIS 3.10 with PostGIS, I needed to create a new database
> user in PG and test that the user could access all tables in each schema. I
> use a "read_only" role to grant access to the tables. The newly created
> user was able to connect to the database, but each schema was inaccessible
> (table list could not be viewed), even though I am 100% sure the role was
> granted with usage on the DB, access to the schema, and read only access to
> each table. I even tested the new user's creds with PGAdmin4 and was able
> to execute a select query on every table in every schema. So, the problem
> is with QGIS 3.10.
>
> Thinking this might be a bug in 3.10, I installed 3.4.13 and the new user
> credentials work. I can access all tables in each schema, as expected. I
> also noticed that the rendering of large PostGIS layers is much slower in
> 3.10 and often leads to a momentary freezing.
>
> So if you are having trouble with PostGIS in 3.10, I recommend downgrading
> to QGIS 3.4, unless someone can recommend a solution -- perhaps a way to
> clear the credential cache or something in 3.10.
>
>

Hi Cliff,

did you check the issues?
https://github.com/qgis/QGIS/issues?utf8=%E2%9C%93&q=is%3Aissue+postgres%7Cpostgis

3.10 has serious issues with PG permissions, most of them have been fixed
already but if you have anything new to add, this is the right time to do
it.


-- 
Alessandro Pasotti
w3:   www.itopen.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191202/16236e50/attachment.html>