Postgres 15 does not work

[justindbaur]

Steps To Reproduce

Using docker pull bitwarden/self-host:beta and a database image of postgres:15 does not work because it fails to migrate the database schema.

Expected Result

The database is successfully migrated.

Actual Result

Logs containing the following happens:

Microsoft.EntityFrameworkCore.Database.Command: Error: Failed executing DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE COLLATION "postgresIndetermanisticCollation" (LC_COLLATE = 'en-u-ks-primary',
    LC_CTYPE = 'en-u-ks-primary',
    PROVIDER = icu,
    DETERMINISTIC = False
);
Exception thrown: 'Npgsql.PostgresException' in Microsoft.EntityFrameworkCore.Relational.dll
The thread 0x8710 has exited with code 0 (0x0).
Exception thrown: 'Npgsql.PostgresException' in System.Private.CoreLib.dll
An unhandled exception of type 'Npgsql.PostgresException' occurred in System.Private.CoreLib.dll
42P17: parameter "locale" must be specified

Screenshots or Videos

No response

Additional Context

This has been resolved by the npgsql team in the 6.0.8 version but that version has not been released yet. Once that has been released we can bump this dependency and try to use postgres 15.

Githash Version

All

Environment Details

N/A

Database Image

postgres:15

Issue-Link

#2480

Issue Tracking Info

• I understand that work is tracked outside of Github. A PR will be linked to this issue should one be opened to address it, but Bitwarden doesn't use fields like "assigned", "milestone", or "project" to track progress.

[justindbaur]

6.0.8 has been released! I would be willing to review a PR that bumps that version so we can begin supporting postgres:15.