Prerequisites

Postgres

In order to run the FactCast server, you have to provide a Postgres database at least in version 15. The following example shows the configuration with one user.

spring.datasource.username="user" //that user has to be provided
spring.datasource.password="password"

The user has to be a superuser, as it will also install Postgres modules like uuid-ossp.

If You Don’t Want to Provide a Superuser

If you don’t want to provide a superuser, you have to consider the following points:

  1. The database user needs at least the permission to query the pg_roles view. According to the documentation it’s publicly accessible, so that shouldn’t be a problem.

  2. FactCast needs the Postgres module uuid-ossp. You have to install that module manually. The server will recognise the already installed module and it won’t throw an error caused by missing privileges. Log in to your Postgres console and execute the following command as superuser:

    CREATE EXTENSION IF NOT EXISTS "uuid-ossp";