FDSA Resources

Use External DB for FDSA management

NOTE: Postgres DBs cannot have names with spaces, ‘-’ or other special characters.

  1. Log in to your database:
    psql -h <HOST IP/url> -p <PORT> -U <user> postgres
  2. Create the 'fdsa_user':
    CREATE USER fdsa_user WITH PASSWORD 'fdsa_pass' SUPERUSER;
  3. Grant necessary access to 'fdsa_user':
    ALTER USER fdsa_user CREATEDB;                   ALTER USER fdsa_user CREATEROLE;
  4. Exit and log in with 'fdsa_user':
    \q;   psql -h <HOST IP/url> -p <PORT> -U fdsa_user postgres;
  5. Create the required databases ('keycloak' and 'fdsa_database') using port 5432 and ensure it is open for FDSA connectivity.
  6. Update the 'Database Credentials' section in the '.env' file with your external database information (PGHOST, PGDATABASE, PGUSER, PGPASSWORD).
  7. When the installer asks if you want to use an external database, answer 'yes'.