Installation issues with Postgres on Ubuntu 24.x

[andypiper]

Reported via email - the user followed our installation instructions to install on "Ubuntu 24" and encountered the error:

PG::InvalidParameterValue: ERROR: new encoding (UTF8) is incompatible
with the encoding of the template database (SQL_ASCII)

They identified the problem:

FIRST, you have to install an encoding that includes UTF-8 using
dpkg-reconfigure locales
(for example, de_DE.UTF-8)

If you haven't done that, the aforementioned error occurs.
If you have done it, the database is created with the correct encoding.

Once the problem exists, the only solution is to completely uninstall and reinstall PostgreSQL.

Please add dpkg-reconfigure locales -> UTF8 to the documentation