Using postgres on Debian GNU/Linux 12 (bookworm)
by zaxonus from LinuxQuestions.org on (#6GW8N)
Here is what happens when I want to use postgres on debian:
~$ psql
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "en_US:en",
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to a fallback locale ("en_US.UTF-8").
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "dolphin" does not exist
~$ psql
I need to fix this problem, so comes my question :
What is the way to check that my locale settings are supported and installed on my debian system ?
~$ psql
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "en_US:en",
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to a fallback locale ("en_US.UTF-8").
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "dolphin" does not exist
~$ psql
I need to fix this problem, so comes my question :
What is the way to check that my locale settings are supported and installed on my debian system ?