(Optional) Configure an external database
Although DPS includes an embedded PostgreSQL database, the embedded database is intended for nonproduction use. You should use an external database for production environments. After installing the database following the instructions provided with the database software, you must set up the database for use with DPS.
- You must have the proper role to perform this task.
- The PostgreSQL database must have been installed and properly configured for remote access.
- A database must have been created.
- A database user must have been created and assigned permissions for the new database.
Open the <installer_home>/config.env.sh file for editing.
Modify the DB Configs settings to add the appropriate connection information.
USE_EXTERNAL_DB="yes" DATABASE_URI="jdbc:postgresql://<host_name>:5432/<database_name>" DATABASE_USER="<user_name>" DATABASE_PASS="<password>"
Your external database is now set up so that you can configure it for DPS during DPS installation.