tip for the documentation: default styles in postgresql do not restore

[qgib]

Author Name: Gavin Fleming (@gubuntu)
Original Redmine Issue: 10079
Affected QGIS version: 2.2.0
Redmine category:documentation_and_help

---

Default layer styles as saved by QGIS are failing to restore after a backup:

pg_restore: [archiver (db)] Error from TOC entry 3479; 0 2188138 TABLE DATA layer_styles
pg_restore: [archiver (db)] COPY failed for table "layer_styles": ERROR: invalid XML content
DETAIL: Entity: line 1: parser error : StartTag: invalid element name

^
CONTEXT: COPY layer_styles, line 1, column styleqml: "
<qgis version="2.2.0-Valmiera" minimumSca..."

[qgib]

Author Name: Gavin Fleming (@gubuntu)

---

you need to set the XML option to DOCUMENT and the restore will work:

http://lists.osgeo.org/pipermail/qgis-user/2014-April/026937.html

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Gavin Fleming wrote:

you need to set the XML option to DOCUMENT and the restore will work:

http://lists.osgeo.org/pipermail/qgis-user/2014-April/026937.html

making this a suggestion for inclusion in the docs

---

• category_id was configured as Documentation and Help
• subject was changed from default styles in postgresql do not restore to tip for the documentation: default styles in postgresql do not restore

[qgib]

Author Name: Alexander Bruy (@alexbruy)

---

Moved to GitHub issues, see qgis/QGIS-Documentation#478

---

• status_id was changed from Open to Closed