[Qgis-user] Recover a project stored in a PostGIS database?

[Thayer Young]

I am wondering if anyone has any ideas of how I can recover a project that is stored in a PostGIS database. When I try to open the project it loads indefinitely (I shut it off after a few hours) for a project that used to load in a minute or so. There is no network activity to suggest that the loading is due to data transfer, etc.. The individual layers load from the database without any problem, so I don't think it is a question of the connection.
I tried the following query 
SELECT "name", 
    convert_from(decode(encode(qgis_projects.content, 'escape'),'escape'), 'Latin1') AS project_latin1,
    encode(qgis_projects.content, 'escape') AS project_hex
FROM qgis_projects     
WHERE "name" = 'my_project'
but with Latin1 and UTF8 I get an error stating ERROR: invalid byte sequence for encoding "UTF8": 0x00 SQL state: 22021
-Thayer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240619/1cc5a7de/attachment.htm>