I’m trying to create a new Postgres database with the following code:

CREATE DATABASE my_db
    WITH
    OWNER = admin
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_GB.utf8'
    LC_CTYPE = 'en_GB.utf8'
    LOCALE_PROVIDER = 'libc'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1
    IS_TEMPLATE = False;

But it fails with the error: ERROR: The chosen LC_CTYPE setting requires encoding "LATIN9".encoding "UTF8" does not match locale "en_GB.utf8" This issue is discussed on SO but solutions are about a Linux system. I’m working in pgAdmin in Windows.

I have checked pg_collation and both en_GB.utf8 and en_US.utf8 (which works) are listed, but if I create a table in the pgAdmin GUI, the only options for collation and character type are C, POSIX and en_US.utf8.

Any idea how to make other locales usable?