We are trying to create a read-only user within the FME Form PostgreSQL DB using pgAdmin logged in as the fmeflow user. We are using the out-of-the box PostgreSQL DB which is installed on the core machine. However, we can’t seem to create a new user. Items (such as right-click menus, etc.) are grayed out. Is there documentation somewhere on how to do this?
We want to query the FME Flow DB directly. Or is this frowned upon?
Version: FME Flow 2024.1.1.0 (Build 24619)
Thanks,
Mark
Re the user, i’ve always found it easier to create them using the CLI rather than PGAdmin. Have a look here: https://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql
Re reading the DB directly, i wouldn’t say its frowned upon per se, it’s more a question of what does the database have that the RestAPI doesn’t give you? https://docs.safe.com/fme/html/FME_REST/apidoc/v3/index.html
The “postgres” user is blocked and the “fmeflow” user doesn’t have permission to do much. You’ll have to modifiy pga_hba.conf to enable trusted connections from localhost so that you can connect as “postgres” without a password. This will enable you to create new users, etc.
However, I share the opinion of