Run fta-setup-postgresql

This step is used to configure the Security Provider service to use a PostgreSQL database for storing identity and access management data. This step is required for production environments, but can be optional for test or development environments.
The script will create a credential store for securely storing the password for the PostgreSQL user and will replace the existing H2 data source with one that uses PostgreSQL. The first argument to the script is a password for the credential store. The second argument is the PostgreSQL user name and the last argument is the password for the PostgreSQL user.
Ensure that the psql path is set in fta-setup-env.sh file. Run the following command:
$ ./fta-setup-postgresql.sh <credential-store-password> <postgresql-username> <postgresql-password>
  • The first argument (credential-store-password) in the script is a password for the credential store. Define the password. For example: Passw0rd01
  • The second argument (postgresql-username) is the PostgreSQL User name.
    NOTE:
    By default, the username for PostgreSQL Superuser is ‘postgres’.
  • The last argument (postgresql-password) is the password for the PostgreSQL User. Use the password defined while installing PostgreSQL, for example: Welcome@123.
    IMPORTANT:
    Make sure that the arguments with special characters are handled correctly and the temporary files created by the scripts are cleaned up. Escaping will be necessary for any of the command arguments with special characters (e.g. $, !)
  • In a Linux environment use single quotes ('') around strings that utilize special characters. For example: If the PostgreSQL password is Welcome! the command would be:
    $ ./fta-setup-postgresql.sh xyzzy postgres 'welcome!'
Refer to Table 1 for the list of the supported special characters that can be used to create a password for the PostgreSQL user.
In a Linux environment use single quotes (‘ ’) around strings that utilize special characters. For example: If the PostgreSQL password is Welcome! the command would be:
$ ./fta-create-postgresql-db.sh postgres ‘Welcome!’ ftasuser ‘Password!’
NOTE:
Write down this password somewhere for future installation steps. Example: Password!
After adding the credential store and configuring the data source the script will restart the Security Provider service.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.