[Solved][PostgreSQL] Error while initializing DB Cluster

pvpmartins · 2022-05-08 03:45:34

Hi! I'm following the PostgreSQL installation guide by ArchWiki.

After installing packages, I just get this error after entering "initdb -D /var/lib/postgres/data" command.

This is what I got:

"initdb: error: invalid locale settings; check LANG and LC_* environment variables"

I did disabled the CoW on /var/lib/postgres directory, since I'm on a btrfs and it was advised in the article to do so.

Last edited by pvpmartins (2022-05-30 02:11:11)

pvpmartins · 2022-05-08 04:12:20

So... When I enter "locale -a" I got this:

locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_COLLATE to default locale: No such file or directory
C
POSIX

I went to the locale.gen file and saw that on the list it was "_US.UTF8" and I thought it should be "en_US.UTF8". So I did altered to the latter.
The error persists.

Last edited by pvpmartins (2022-05-08 04:12:38)

Slithery · 2022-05-08 04:14:45

Did you regenerate your locales after editing the file?
https://wiki.archlinux.org/title/Locale

pvpmartins · 2022-05-08 21:10:17

Thank you! Just did it and it worked!

I thought I wouldn't need to use "locale-gen" once I edited the locale.gen file.

Thank you again.

Slithery · 2022-05-08 21:30:27

Please remember to mark the thread as [SOLVED].
CoC - How to post

Arch Linux

#1 2022-05-08 03:45:34

[Solved][PostgreSQL] Error while initializing DB Cluster

#2 2022-05-08 04:12:20

Re: [Solved][PostgreSQL] Error while initializing DB Cluster

#3 2022-05-08 04:14:45

Re: [Solved][PostgreSQL] Error while initializing DB Cluster

#4 2022-05-08 21:10:17

Re: [Solved][PostgreSQL] Error while initializing DB Cluster

#5 2022-05-08 21:30:27

Re: [Solved][PostgreSQL] Error while initializing DB Cluster

Board footer