Use External DB for FDSA management
NOTE: Postgres DBs cannot have names with spaces, ‘-’ or other special characters.
- Log in to your database:
psql -h <HOST IP/url> -p <PORT> -U <user> postgres - Create the 'fdsa_user':
CREATE USER fdsa_user WITH PASSWORD 'fdsa_pass' SUPERUSER; - Grant necessary access to 'fdsa_user':
ALTER USER fdsa_user CREATEDB; ALTER USER fdsa_user CREATEROLE; - Exit and log in with 'fdsa_user':
\q; psql -h <HOST IP/url> -p <PORT> -U fdsa_user postgres; - Create the required databases ('keycloak' and 'fdsa_database') using port 5432 and ensure it is open for FDSA connectivity.
- Update the 'Database Credentials' section in the '.env' file with your external database information (PGHOST, PGDATABASE, PGUSER, PGPASSWORD).
- When the installer asks if you want to use an external database, answer 'yes'.