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

[Jorge Gustavo Rocha via QGIS-User]

Hi, Export the project from the database to the file system: copy  (SELECT  
encode(content,  'hex')  FROM  public.qgis_projects  where  name  =  
'my_project')  to   '/tmp/project.hex'; cd  /tmp
xxd -p -r project.hex > project.qgz

I hope it helps,

Jorge

On 19/06/24 19:56, Thayer Young via QGIS-User wrote:
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

___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

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

[Thayer Young via QGIS-User]

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
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user