Create the Repository Database

The Colectica Repository makes use of two databases per installation, one database to store the metadata content and another that is used by the web portal. You may use whatever name you wish for the databases, by default the documentation refers to them as the colectica and colectica-portal databases.

Installing releases greater than 7.2.9461

The database is automatically populated and managed by the application. The database user should have permission to modify the database schemas.

SQL Server

  1. Connect to your SQL Server.

  2. Create a database named colectica.

  3. Create a database named colectica-portal.

PostgreSQL

  1. Connect to your PostgreSQL server.

  2. Create a database named colectica.

  3. Create a database named colectica-portal.

Note

The Postgres provider will automatically install the unaccent extension that is included in PostgreSQL.

  1. On Azure hosted PostgreSQL database flexible server, the unaccent module must be added to the list of allowed extensions via the Azure Portal. See https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions

  2. On Azure hosted PostgreSQL database single server, a super user must install the extension. Run CREATE EXTENSION unaccent; on the colectica database before running the software.

  3. On PostgreSQL versions lower than 13, a super user must install the extension. Run CREATE EXTENSION unaccent; on the colectica database before running the software.

Installing earlier releases

SQL Server

  1. Connect to your SQL Server.

  2. Create a database named colectica.

  3. Run the SQL commands in RepositoryDir\scripts\v7\sqlserver-RepositorySchema-v6.sql on the colectica database.

  4. Create a database named colectica-portal. This database is automatically populated and managed by the application.

PostgreSQL

  1. Connect to your PostgreSQL server.

  2. Create a database named colectica.

  3. Run the SQL commands in RepositoryDir\scripts\v7\postgresql-RepositorySchema-v6.sql on the colectica database.

  4. Create a database named colectica-portal. This database is automatically populated and managed by the application.