FME Flow Database on PostgreSQL with a Custom Schema

SteveatSafe
SteveatSafe
  • Updated

Introduction

By default, the FME Flow database user, fmeflow, uses the public schema in the fmeflow database.

Database administrators may choose to alter the schema that FME Flow uses in the PostgreSQL database.  

An approach you can use is to create the desired schema, for example, ‘fmeflow’ and assign appropriate permissions to it for the fmeflow user, and have it set as the default search path.

For example, as the postgres user:

CREATE DATABASE fmeflow;
CREATE USER "fmeflow" WITH PASSWORD ‘your secure password’;
CREATE SCHEMA fmeflow;
GRANT USAGE ON SCHEMA fmeflow TO fmeflow;
ALTER ROLE fmeflow SET search_path TO fmeflow;
GRANT ALL PRIVILEGES ON DATABASE fmeflow TO fmeflow;

Once this is completed, log into the PosgreSQL database as the fmeflow user and run the postgresql_createSchema.sql to create the FME Flow database objects.  Confirm the objects (tables) were created in the correct schema.  

There should not be any need for changes to the fme_DatabseConfig.txt as long as the correct user and database are already set there. 

 

Additional Resources 

Configure FME Flow Database on Separate Server (2-Tier)

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.