Postgres Pro
Downloads
Home   >   mailing lists

Thread: Warning when using psql

Warning when using psql

From
Jean Thomas SERVANT
Date:
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

From
Pavan Teja
Date:

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

From
Tom Lane
Date:
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