Ah! You’ll also need to set
DISCOURSE_DB_BACKUP_PORT: 9432
and then things should work.
EDIT: this default has been in place for a while but seems to have caused more difficulty than good.
FIX: clear db_backup_port default value by Supermathie · Pull Request #25316 · discourse/discourse · GitHub also should resolve this and avoid this confusion for future travellers