Warning when using psql
Hi,
Here is my issue with PostgreSQL :
When I connect to a database, I have the following error message :
WARNING: could not determine encoding for locale "fr_FR": codeset is
"ANSI_X3.4-1968"
DETAIL: Please report this to <pgsql-bugs@postgresql.org>.
May you help me please ? These error messages fill the logs, and my
teammates developers also have other issues with their applications because
of that.
Configuration :
- Servers : RedHat 7 / CentOS 7
- PostgreSQL Server 9.6 (installed from RedHat SCL)
Thanks a lot.
<http://www.aca.fr/> Jean-Thomas SERVANT
*Administrateur système*
69 Rue De Monceau 75008 Paris - France
<https://www.linkedin.com/groups/3967314/profile>
<https://twitter.com/aca_tweet/>
<https://www.youtube.com/channel/UC_zN9SIu9ZUp5T7ldyEHRSA>
Meanwhile, the warning isn't really hurting anything, it's just letting
you know that Postgres is not sure whether your locale and encoding
settings match. As long as you don't tell it to use something besides
the LATIN1 encoding in this locale, everything will work fine.
Regards,
Pavan
On Tue, Jun 5, 2018, 10:27 PM Jean Thomas SERVANT <
jean-thomas.servant@aca.fr> wrote:
Show quoted text
Hi,
Here is my issue with PostgreSQL :
When I connect to a database, I have the following error message :
WARNING: could not determine encoding for locale "fr_FR": codeset is
"ANSI_X3.4-1968"
DETAIL: Please report this to <pgsql-bugs@postgresql.org>.May you help me please ? These error messages fill the logs, and my
teammates developers also have other issues with their applications because
of that.Configuration :
- Servers : RedHat 7 / CentOS 7
- PostgreSQL Server 9.6 (installed from RedHat SCL)Thanks a lot.
<http://www.aca.fr/> Jean-Thomas SERVANT
*Administrateur système*
69 Rue De Monceau 75008 Paris - France
<https://www.linkedin.com/groups/3967314/profile>
<https://twitter.com/aca_tweet/>
<https://www.youtube.com/channel/UC_zN9SIu9ZUp5T7ldyEHRSA>
Jean Thomas SERVANT <jean-thomas.servant@aca.fr> writes:
When I connect to a database, I have the following error message :
WARNING: could not determine encoding for locale "fr_FR": codeset is
"ANSI_X3.4-1968"
DETAIL: Please report this to <pgsql-bugs@postgresql.org>.
Try setting your locale to something that specifies a particular
encoding, say "fr_FR.utf8" or "fr_FR.iso88591" (use "locale -a"
to see what's available).
I'm not really sure what's wrong with your fr_FR locale; I've not
seen such messages on Red Hat systems myself. But it seems like
something's misconfigured somewhere.
regards, tom lane