You are not logged in.
I guess some kind of configuration got messed up when running pacman -Syu yesterday. Today I booted up and tried to start my postgresql server and came across some errors.
$ sudo systemctl start postgresql.service
Starting PostgreSQL database server...
2018-10-17 12:09:46.842 EDT [3025] LOG: invalid value for parameter "lc_messages": "en_US.UTF-8"
2018-10-17 12:09:46.842 EDT [3025] LOG: invalid value for parameter "lc_monetary": "en_US.UTF-8"
2018-10-17 12:09:46.842 EDT [3025] LOG: invalid value for parameter "lc_numeric": "en_US.UTF-8"
2018-10-17 12:09:46.842 EDT [3025] LOG: invalid value for parameter "lc_time": "en_US.UTF-8"
2018-10-17 12:09:46.842 EDT [3025] FATAL: configuration file "/var/lib/postgres/data/postgresql.conf" contains errorsThis is what I get when I enter $locale
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_ALL to default locale: No such file or directory
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=en_US.UTF-8And this is what I get when I enter $locale -a
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
POSIXDoes anyone know how to fix this so I can get postgresql running agian?
Last edited by jmannonpdx (2018-10-17 17:04:00)
Offline
I'm assuming glibc was updated? It appears there was a problem generating locales. Go through that process again.
Offline
When glibc gets updated it also regenerates your locales, based on the information in /etc/locale.gen Did you ever comment the en_US.UTF-8 again or replace the file with the default or similar? https://wiki.archlinux.org/index.php/Lo … ng_locales
Also in general last pacman -Syu is something different for everyone and useless for debug information, check what got updated post the transaction information from your pacman.log in doubt.
Offline
When glibc gets updated it also regenerates your locales, based on the information in /etc/locale.gen Did you ever comment the en_US.UTF-8 again or replace the file with the default or similar? https://wiki.archlinux.org/index.php/Lo … ng_locales
Also in general last pacman -Syu is something different for everyone and useless for debug information, check what got updated post the transaction information from your pacman.log in doubt.
Thanks! removing the comment in /etc/locale.gen did the trick. Did upgrading glibc add the comment back?
Offline
Did upgrading glibc add the comment back?
No, the glibc package has that file in it's backup array, so pacman will install the file as a pacnew if you have made any changes to the file on the filesystem.
Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD
Making lemonade from lemons since 2015.
Offline