iPad won't sync a project that uses a Postgres view?

Ask the Community
1

I have a QGIS project that has an OpenStreet basemap and a layer based on a Postgres view created in a remote database. That’s it!

CREATE OR REPLACE VIEW mmap_geom AS
SELECT
  "SiteID" as id,
  "Site_Name" as name,
  "Point_Y" as latitude,
  "Point_X" as longitude,
  ST_SetSRID(ST_MakePoint("Point_X", "Point_Y"), 4326) AS geom
FROM "tblSite";

I have successfully synced the package from my desktop QGIS setup to the Cloud (I checked the timestamps of files, etc.) So the 2 files in the project are up there:

Project files

2 project files in total using 246.5 KB.
MMAP files
    MMAP_attachments.zip - 2.1 KB by owner
    MMAP.qgs - 80.2 KB by owner

I’m trying to sync this project to my iPad but I keep getting “403 permission denied” on the app running on the iPad.

Oh yes: the user on the client and of the Project are the same: the owner of the project.

I have created a .pgconfig on the server, but I admit I have no idea how this is sposed to enable the connection between the iPad client and the Postgres server, if at all. It’s not necessary to have a “live” connection, but it is necessary to be able to update the Project on the various clients based on the content in the database.

TYIA!

Imported from GitHub discussion by @jblowe on 2025-06-26T04:56:39Z