Hello community,
I’m trying to enable editing for a PostgreSQL vector layer in Lizmap, but I’m encountering errors. The layer displays fine in the web, but the editing form fails to load.
Setup I have:
- Lizmap Web Client 3.8.10
- QGIS server 3.42.2
- PostgreSQL 17.2
- PostGIS 3.5.0
What I have configured (based on documentation):
- The vector layer is stored in PostgreSQL, and is correctly displayed in Lizmap Web Client.
- No spaces in field names of vector layer.
- Editing tool is configured in QGIS.
- The layer is published as WFS.
- Credentials are set in the QGIS project file:
<datasource>dbname='lizmap' key='ogc_fid' user='lizmap' password='password' port=5432 host='db.lizmap' table="public”.”table” (wkb_geometry)</datasource>
When I try to edit the layer in the Lizmap web interface:
- Web app frontend:
Error while fetching the editing form for that layer. Please contact the system administrator. - Lizmap logs:
2025-05-23 19:38:51 [2] pg_connect(): Unable to connect to PostgreSQL server: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket? /www/lizmap/vendor/jelix/jelix/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 168
2025-05-23 19:38:51 [402] error durante la conexión /www/lizmap/vendor/jelix/jelix/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 184
Any help would be appreciated:
- Is there a separate configuration needed to tell Lizmap how to connect for editing?
- What else can I check or enable for editing to work properly?
Thanks in advance!