Running psql -l shows that maps-test* postgres DBs were created with SQL_ASCII, whereas all our production servers have it set to UTF8.
|Open||Gehel||T137939 Increase frequency of OSM replication|
|Resolved||Gehel||T147194 reimage maps-test* servers|
|Resolved||Gehel||T148031 Maps - error when doing initial tiles generation: "Error: could not create converter for SQL_ASCII""|
|Resolved||Gehel||T148114 Maps-test was created with incorrect initial encoding|
Strange thing is that other servers have been reimaged recently and database were created with UTF-8 encoding. There is probably a missing dependency somewhere in Puppet. I'm having a look...
The issue seems to be that when puppet is run manually, the $LANG variable is set, which is used by initdb to guess at the correct encoding. When puppet is run non interactively, which is the case during re-image, encoding falls back to SQL_ASCII. Setting the encoding / locale explicitly should fix that.