postgres: Allow specifying locale per-machine

Synapse needs the database to be in C locale. Since v1.56.0, it refuses to start when this is not the case, see upgrade.md.

Replace en_US.UTF-8 with a variable where present and adapt the upgrade_pg.sh script to copy the locale from the old cluster.