...
- Start by installing the "pgcrypto" module (must have version 1.1 or above for the "gen_random_uuid()" method, see
)Jira server DuraSpace JIRA serverId c815ca92-fd23-34c2-8fe3-956808caf8c5 key DS-2716 - In many Linux systems (especially Debian/Ubuntu), pgcrypto is provided in the "postgresql-contrib" package.
- In many Linux systems (especially Debian/Ubuntu), pgcrypto is provided in the "postgresql-contrib" package.
- Connect to the database using user postgres
- Run the following command: "CREATE EXTENSION pgcrypto;"
- The output of the command if successful is blank, so you can always try to run "SELECT gen_random_uuid();" which should return a result.
...