| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | vinod(dot)t(dot)v(at)outlook(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14794: Installation failure if user specify French password |
| Date: | 2017-10-06 05:50:20 |
| Message-ID: | 20171006055020.GA427951@rfd.leadboat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Sep 01, 2017 at 10:15:37AM +0000, vinod(dot)t(dot)v(at)outlook(dot)com wrote:
> I have specified
> Télécharger as the password during postgres installation in french OS.
> installation failed.
> ex‚cution de l'initialisation aprŠs bootstrap...FATAL: sǸquence d'octets
> invalide pour l'encodage ¶® UTF8 ¶¯ : 0xe0 0x74 0x27
This is a character encoding mismatch. Within an established database
session, PostgreSQL has robust encoding conversion. During initdb and
connection establishment, encoding treatment is much more primitive. This has
been on https://wiki.postgresql.org/wiki/Todo for years, and fixing it is low
priority. I recommend using only ASCII in user names, passwords, and database
names.
If you still want this, set an ASCII password during installation, and then
change it with ALTER USER. This will work well only if all your client
software sends the password in the same encoding as the database where you
issue ALTER USER (probably UTF8).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Binderman | 2017-10-06 07:21:33 | postgresql-10.0/src/bin/psql/mainloop.c:465: suspicious condition ? |
| Previous Message | Andres Freund | 2017-10-06 05:21:05 | Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql |