Connect to Internal FDSA DB

Use these steps if you need to connect directly to the internal FDSA PostgreSQL database running in the fdsa_db Docker container, for troubleshooting or inspection.

The connection between the server and the docker Database is made through the Docker CLI.

1. Check database settings in .env
Confirm the following variables match your FDSA configuration:

PGDATABASE='fdsa_appliance'

PGUSER='<user>'

PGPASSWORD='<password>'

PGPORT=<port>

2. Enter the database container
From the FDSA host server, run:

docker exec -it fdsa_db bash

3. Connect to PostgreSQL with psql
Inside the container, connect using the same values:

psql -d <PGDATABASE> -U <PGUSER>

Note: Changes made directly in the internal FDSA database can affect system behavior. Only experienced administrators or DBAs should modify data or schema here.