Обсуждение: Warning when using psql

Поиск
Список
Период
Сортировка

Warning when using psql

От
Jean Thomas SERVANT
Дата:
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.



Jean-Thomas SERVANT 
Administrateur système
69 Rue De Monceau 75008 Paris - France
    

Re: Warning when using psql

От
Pavan Teja
Дата:

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:
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.



Jean-Thomas SERVANT 
Administrateur système
69 Rue De Monceau 75008 Paris - France
    

Re: Warning when using psql

От
Tom Lane
Дата:
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