Category: Databases

Install DSpace 6.x

Install DSpace 6.x on Ubuntu 18.04 -Step 1

Install Dspace 6.x prerequisite applications Below is the the first steps on how to Install Dspace 6.x Digital Repository. Open  Applications > Accessories > Terminal and execute the following commands. Apply following commands, Install vim Editor, Java JDK, Postgresql, ant and Maven Login to PostgreSQL and create the database Enter a password for new role: [Enter a password…
Read more

August 11, 2021 0

Required PostgreSQL pgcrypto extension is NOT INSTALLED on this database.

Pgcrypto extension is NOT INSTALLED Pgcrypto extension is NOT INSTALLED is a Common error with pgcrypto but you have to not that this extension is installed per database,Common error is to install it on the default postgres user. Therefore while installing DSPACE do the do following : CREATE EXTENSION

July 27, 2021 0
new encoding (UTF8) is incompatible

ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

Please follow the steps below to sought the above postgresql ERROR: new encoding (UTF8) is incompatible We need to drop or modify template1. Templates can’t be dropped, hence we need to make make an database: ERROR: new encoding (UTF8) is incompatible su postgres psql UPDATE pg_database SET datistemplate = FALSE WHERE datname = ‘template1’; Now…
Read more

July 22, 2021 1