This article provides a solution for a PostgreSQL collation issue encountered while creating a database with the Canadian en_CA.UTF-8 collation on a RedHat Enterprise Linux 9 server.