Installing Database
Install PostgreSQL
apt install postgresql postgresql-client -y
Create user dspace with password dspace in PostgreSQL.
su postgres
createuser -U postgres -d -A -P dspace
exit
Create a database for dspace.
sudo -u dspace createdb -U dspace -E UNICODE dspace
Activating the pgcrypto extension.
su postgres
psql --username=postgres dspace -c "CREATE EXTENSION pgcrypto;"
exit
Open the PostgreSQL configuration file pg_hba.conf.
nano /etc/postgresql/12/main/pg_hba.conf
Add the following configuration at the very bottom line.
local all dspace md5
Restart PostgreSQL.
systemctl restart postgresql
systemctl status postgresql
No Comments