sameersbn
[Feature] Collation Support for postgres backend
Faced out with insensitive search issue for internationalized redmine. Also can be many other drawback.
The problem is, that by default postgres database is created with 'C' collation. But is is not the right case for 'Russian' or any other language.
So, I have to extend sameersbn/docker-postgresql image with a Dockerfile with command RUN locale-gen ru_RU.UTF-8 && dpkg-reconfigure locales
And do backup / drop / create db with 'ru' collation / restore db :
docker exec -it redmine_postgresql_1
bash -c "pg_dumpall -v -U postgres -l redmine_production > /var/lib/postgresql/redmine_production.dmp"
docker exec -it redmine_postgresql_1 bash psql -U postgres DROP DATABASE redmine_production; CREATE DATABASE redmine_production WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'ru_RU.UTF-8' LC_CTYPE = 'ru_RU.UTF-8'; \q exit
docker exec -it redmine_postgresql_1
bash -c "psql -U postgres -f /var/lib/postgresql/redmine_production.dmp redmine_production"
Maybe it should be mentioned in readme, because is really critical for localized redmine installation
