@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
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 -
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