Build postgres with support for locale en_US.UTF-8

Help
1

Hello,
I am building a postgres image with nix2container that I am planning to use to replace the official one. The issue is that all databases created with the standard image are created with the LC_COLLATE set to en_us.UTF-8 but the postgres build in nix doesn’t seem to come with it, leading to the following issue:

The database was initialized with LC_COLLATE "en_US.UTF-8",  which is not recognized by setlocale().

Does anyone know how to override the postgres derivation to include utf-8 locales?

Thanks!

2

Ok, I managed to figure this one out, adding "LOCALE_ARCHIVE=${pkgs.glibcLocalesUtf8}/lib/locale/locale-archive" to the environment did the trick.