QGIS + QFieldCloud + PostgreSQL - layers invalid on QField Android

[bruceb]

We have a QGIS project connected to a PostgreSQL/PostGIS database on Google Cloud SQL. The project is uploaded to QFieldCloud. The “Process QGIS Project File” job completes successfully with all green ticks. However the “Package” job is failing — all layers show invalid_dataprovider in QFieldCloud and red exclamation marks on QField Android.

We have uploaded the pg_service.conf as a QFieldCloud Secret. The service name in the file matches the connection in QGIS. The project processes fine but packaging fails, meaning QFieldCloud cannot connect to PostgreSQL when trying to create the offline GeoPackage for the field team.

What we need help with Why does the Package job fail to connect to PostgreSQL even though the Process Project File job passes? Is there a specific way the pg_service.conf Secret needs to be referenced in the QGIS layer connections for the Package job to pick it up correctly?

QField version: latest Android. QFieldCloud plan: paid. PostgreSQL on Google Cloud SQL.

[cuprico]

Hello! I haven’t tried it myself, but did you check Working with PostgreSQL on the QField docs and Secrets on the QFieldCloud docs? They seem to be pretty comprehensive. Some details that are mentioned there like:

1. You have manually copy the service file if you are using wire transfers
2. additional configuration steps for windows
3. setting environment variables on QGIS
4. secrets organization and configuration
5. database configuration
6. etc

might be of help to make a throughout check to see if everything seems in order.