PostgreSQL initdb: invalid locale name "en_US.UTF-8"

Aegidius · 2015-10-10 17:05:43

Hello all,

I am following the wiki in order to install and run PostgreSQL but I am getting this error.

[postgres@archlinux ~]$ initdb --locale en_US.UTF-8 -E UTF8 -D '/var/lib/postgres/data'
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

initdb: invalid locale name "en_US.UTF-8"

Do you know why the locale name is not valid?

mencargo · 2015-11-10 02:59:11

I had the same problem.

Check that the correct LANG is set in /etc/locale.conf

cat /etc/locale.conf
LANG=en_US.UTF-8

Then do sudo locale-gen and try that again

Scimmia · 2015-11-10 04:24:50

Sounds like you don't have that locale generated. Check /etc/locale.gen, then run locale-gen as mencargo suggested.

jramirezg · 2017-04-12 12:51:04

Hell have the same problem I have KDE and Archlinux installed and postgresql gives me the same error, this forum trend is about 2 years old and I can't seem to find a solution for this problem.
thanks for your help

jramirezg · 2017-04-12 12:52:33

[postgres@lockdurn data]$ initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data'
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

initdb: invalid locale name "en_US.UTF-8"

WorMzy · 2017-04-12 15:08:40

So do as mencargo & Scimmia suggested. If you still have trouble, open a new thread. Be sure to share with us the content of /etc/locale.conf and output of locale-gen, using code tags.

https://wiki.archlinux.org/index.php/Co … bumping.22

Closing.

Arch Linux

#1 2015-10-10 17:05:43

PostgreSQL initdb: invalid locale name "en_US.UTF-8"

#2 2015-11-10 02:59:11

Re: PostgreSQL initdb: invalid locale name "en_US.UTF-8"

#3 2015-11-10 04:24:50

Re: PostgreSQL initdb: invalid locale name "en_US.UTF-8"

#4 2017-04-12 12:51:04

Re: PostgreSQL initdb: invalid locale name "en_US.UTF-8"

#5 2017-04-12 12:52:33

Re: PostgreSQL initdb: invalid locale name "en_US.UTF-8"

#6 2017-04-12 15:08:40

Re: PostgreSQL initdb: invalid locale name "en_US.UTF-8"

Board footer