To connect to a PostgreSQL database, many tools allow to use a pgpass file (https://www.postgresql.org/docs/current/libpq-pgpass.html) or a pg_service file (https://www.postgresql.org/docs/current/libpq-pgservice.html).
It could be great to use such files in FME with the postgresql reader/writer and the SQL executor.
Three options :
- Use the selected connexion (current behaviour)
- Use the pgpass file, fme display a form to set infromations on the connexion and use the selected pgpass line corresponding to the data specified in FME (nothing = 1st line, host or host+port or host+port+user or host+port+user+db = 1st corresponding line) to get the required data to connect
- For pg_service file, fme display a “service name” input and use the configuration specified by the service name.
