QField, QGIS, PostgreSQL working with enterprise database

Question

I am trying to connect many devices together for data capturing using QField 1.9.6 and PostgreSQL. I prepared the data with QGIS 3.20.1, but I keep getting errors when am not using the store options for login. I am doing this because I want each user to login with his own username and password when using QField. I already created in PostgreSQL with roles.

Is there any way to make this happen? I tried to change hba file to trust all connection Disable SSL, no action layer in QGIS Can't find qfield/auth/ directory

Some Reference for other methods

https://www.opengis.ch/2019/10/03/qfield-1-2-released/ https://docs.qgis.org/3.4/en/docs/user_manual/auth_system/auth_workflows.html https://docs.qgis.org/3.16/en/docs/user_manual/auth_system/auth_overview.html

Answer 1

So I found an Answer as Matthis kuhn suggested to use pg_service.conf.

So I am using widows, and I created a file include each user name and password, then I set it in postgres and I added it to qdield folder in each tablet per user, to use with desktop you need to include the dot IN front of the file name as .pg.service.conf and in qfield remove the dot.