On Jul 12, dev wrote:
hey everybody,
Hello, and welcome to the mailing list!
since there is no forum, AFAIK, I just subscribed and hope get infos
here
instead of (mis)using github-issues…
There is no forum. I feel that creating one would add yet another place me and
other people would have to keep track of. Mailing list messages just come to
your usual mailbox, and you don't need to do anything to keep track of things.
Although, an upgrade to Mailman 3 could probably improve the usability a bit,
with web-based forum-like system. But that would have to go through DebOps
first, so a new set of roles for Mailman, especially that mailman3 packages
are now available in Debian.
Q: how to set lc_collate on postgres DB-creation?
Good question! At the moment the 'debops.postgresql_server' role uses the
'pg_createcluster' script to create new PostgreSQL clusters. There is an
option for setting up locale (via item.locale) parameter, but not specifically
collation. You can see the code here:
https://github.com/debops/debops/blob/master/ansible/roles/debops.postgre...
Would setting the locale suffice in your case, or do you need to set collation
specifically? I suppose that adding the --lc-collate parameter with default
the same as --locale wouldn't hurt. I'm not sure how often that option has to
be differently set than the locale.
Anyway, to change the locale for all clusters, you can set in the inventory:
#v+
postgresql_server__locale: 'en_US.UTF-8'
#v-
For the default cluster only, at the moment the easiest way would be to
override the main cluster variable definition:
#v+
postgresql_server__cluster_main:
name: 'main'
port: '5432'
locale: 'en_US.UTF-8'
#v-
Let me know if that helped,
Maciej