[dspace-tech] Re: Dspace 7.4 backend pgcrypto extension not installed error

2022-12-04 Thread Mohammad S. AlMutairi
@Tim I hope you see this to fix/add an extra missing step to the pgcrypto extention creation in the domcumentation so no user will face the warning message Jeff posted if the user chose to create the extention on the dspace database instead of adding it to a schema. Executing psql

[dspace-tech] Re: Dspace 7.4 backend pgcrypto extension not installed error

2022-12-03 Thread Mohammad S. AlMutairi
Hi Jeff, It is created but it can not be found because it's not included in the search path. One way of fixing this is to create a schema for all extensions first and then create the pgcrypto extension and add it to that schema. Just follow the steps you see below to pass the error. 1) su -

[dspace-tech] Re: Dspace 7.4 backend pgcrypto extension not installed error

2022-12-02 Thread Jeff Mitchell
Just to clarify I had run this already and restarted PSQL as well before running the build and install # Login to the database as a superuser, and enable the pgcrypto extension on this database psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;" On Friday, December 2, 2022 at