PostgreSQL

Creation of the database

1. Start the PostgreSQL console as root

   psql -h localhost -U root –p 5432

2. Create a database

   CREATE DATABASE SOLUTIONHUB;

3. Create a user for the database

warning

The password of the SOLUTIONHUB database user should be changed for security reasons!

```sql
CREATE USER SOLUTIONHUB WITH PASSWORD 'SOLUTIONHUB';
```

4. Grant all rights of the database to the user

```sql
GRANT ALL PRIVILEGES ON DATABASE SOLUTIONHUB TO SOLUTIONHUB;
```

5. Log out as root

```bash
\q
```

6. Set up the database by following the steps described in Flyway database setup