problem installing postgres in debian8 from debian repository

Lists: Postg토토 사이트SQL : Postg토토 사이트SQL 메일 링리스트 : 2016-04-22 이후 PGSQL-BUGS 15:30
From: Armando Perryman Morales <perryman(at)softel(dot)cu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem installing postgres in debian8 from debian repository
Date: 2016-04-22 15:30:12
Message-ID: 571A4384.60606@softel.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg토토 사이트SQL : Postg토토 사이트SQL 메일 링리스트 : 2016-04-22 이후 PGSQL-BUGS 15:30

WARNING: 01000: could not determine encoding for locale "en_US.UTF8":
codeset is "ANSI_X3.4-1968"
DETAIL: Please report this to <pgsql-bugs(at)postgresql(dot)org>.
LOCATION: pg_get_encoding_from_locale, chklocale.c:389
could not determine encoding for locale "en_US.UTF8": codeset is
"ANSI_X3.4-1968"
initdb: could not find suitable encoding for locale "en_US.UTF8"
Rerun initdb with the -E option.
Try "initdb --help" for more information.
Error: initdb failed
Error: could not create default cluster. Please create it manually with

1986-2016: 30 Aniversario de Softel


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Armando Perryman Morales <perryman(at)softel(dot)cu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: problem installing postgres in debian8 from debian repository
Date: 2016-04-22 21:44:01
Message-ID: 32573.1461361441@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Armando Perryman Morales <perryman(at)softel(dot)cu> writes:
> could not determine encoding for locale "en_US.UTF8": codeset is
> "ANSI_X3.4-1968"
> initdb: could not find suitable encoding for locale "en_US.UTF8"

I believe that "ANSI_X3.4-1968" just refers to the original ASCII
standard, so this result means your system's locale data is broken.
A supposedly-UTF8 locale should surely report some spelling of "UTF8"
as its codeset. In any case, "ANSI_X3.4-1968" is a useless response,
as there's almost no codeset in use today that's not a superset of that;
what we need to know in practice is *which* superset.

Check your locale-related packages. I don't know exactly which those
would be on Debian.

regards, tom lane