Diaspora* échoue à s'installer à cause de postgresql13

Hello everybody, help much appreciated

My YunoHost server

Hardware: VMWare Workstation 17 8TB direct attached disk 4GB RAM one processor
YunoHost version: 11.1.20 (stable)
I have access to my server : direct access via keyboard / screen
Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : no
app: Diaspora* 0.7.18.1~ynh1

Description of my issue

Voici des messages d’erreurs
root@ratkovic:/var/lib/postgresql# yunohost service log postgresql
journalctl:

  • – Journal begins at Fri 2022-08-12 19:59:44 CEST, ends at Thu 2023-06-01 20:58:32 CEST. –
  • Jun 01 19:49:56 systemd[1]: postgresql@13-main.service: Failed with result ‘protocol’.
  • Jun 01 19:49:56 systemd[1]: Failed to start PostgreSQL Cluster 13-main.
  • Jun 01 19:55:47 systemd[1]: Starting PostgreSQL Cluster 13-main…
  • Jun 01 19:55:47 postgresql@13-main[80559]: Error: /usr/lib/postgresql/13/bin/pg_ctl /usr/lib/postgresql/13/bin/pg_ctl start -D /var/lib/postgresql/13/main -l /var/log/postgresql/postgresql-13-main.log -s -o -c config_file=“/etc/postgresql/13/main/postgresql.conf” exited with status 1:
  • Jun 01 19:55:47 postgresql@13-main[80559]: 2023-06-01 19:55:47.171 CEST [80568] LOG: invalid value for parameter “lc_messages”: “en_US.UTF-8”
  • Jun 01 19:55:47 postgresql@13-main[80559]: 2023-06-01 19:55:47.171 CEST [80568] LOG: invalid value for parameter “lc_monetary”: “en_US.UTF-8”
  • Jun 01 19:55:47 postgresql@13-main[80559]: 2023-06-01 19:55:47.171 CEST [80568] LOG: invalid value for parameter “lc_numeric”: “en_US.UTF-8”
  • Jun 01 19:55:47 postgresql@13-main[80559]: 2023-06-01 19:55:47.171 CEST [80568] LOG: invalid value for parameter “lc_time”: “en_US.UTF-8”
  • Jun 01 19:55:47 postgresql@13-main[80559]: 2023-06-01 19:55:47.171 CEST [80568] FATAL: configuration file “/etc/postgresql/13/main/postgresql.conf” contains errors
  • Jun 01 19:55:47 postgresql@13-main[80559]: pg_ctl: could not start server
  • Jun 01 19:55:47 postgresql@13-main[80559]: Examine the log output.
  • Jun 01 19:55:47 systemd[1]: postgresql@13-main.service: Can’t open PID file /run/postgresql/13-main.pid (yet?) after start: Operation not permitted
  • Jun 01 19:55:47 systemd[1]: postgresql@13-main.service: Failed with result ‘protocol’.
  • Jun 01 19:55:47 systemd[1]: Failed to start PostgreSQL Cluster 13-main.
  • Jun 01 20:37:31 systemd[1]: Starting PostgreSQL Cluster 13-main…
  • Jun 01 20:37:31 postgresql@13-main[84807]: Error: /usr/lib/postgresql/13/bin/pg_ctl /usr/lib/postgresql/13/bin/pg_ctl start -D /var/lib/postgresql/13/main -l /var/log/postgresql/postgresql-13-main.log -s -o -c config_file=“/etc/postgresql/13/main/postgresql.conf” exited with status 1:
  • Jun 01 20:37:31 postgresql@13-main[84807]: 2023-06-01 20:37:31.776 CEST [84816] LOG: invalid value for parameter “lc_messages”: “en_US.UTF-8”
  • Jun 01 20:37:31 postgresql@13-main[84807]: 2023-06-01 20:37:31.776 CEST [84816] LOG: invalid value for parameter “lc_monetary”: “en_US.UTF-8”
  • Jun 01 20:37:31 postgresql@13-main[84807]: 2023-06-01 20:37:31.776 CEST [84816] LOG: invalid value for parameter “lc_numeric”: “en_US.UTF-8”
  • Jun 01 20:37:31 postgresql@13-main[84807]: 2023-06-01 20:37:31.776 CEST [84816] LOG: invalid value for parameter “lc_time”: “en_US.UTF-8”
  • Jun 01 20:37:31 postgresql@13-main[84807]: 2023-06-01 20:37:31.776 CEST [84816] FATAL: configuration file “/etc/postgresql/13/main/postgresql.conf” contains errors
  • Jun 01 20:37:31 postgresql@13-main[84807]: pg_ctl: could not start server
  • Jun 01 20:37:31 postgresql@13-main[84807]: Examine the log output.
  • Jun 01 20:37:31 systemd[1]: postgresql@13-main.service: Can’t open PID file /run/postgresql/13-main.pid (yet?) after start: Operation not permitted
  • Jun 01 20:37:31 systemd[1]: postgresql@13-main.service: Failed with result ‘protocol’.
  • Jun 01 20:37:31 systemd[1]: Failed to start PostgreSQL Cluster 13-main.
  • Jun 01 20:41:25 systemd[1]: Starting PostgreSQL Cluster 13-main…
  • Jun 01 20:41:25 postgresql@13-main[85963]: Error: /usr/lib/postgresql/13/bin/pg_ctl /usr/lib/postgresql/13/bin/pg_ctl start -D /var/lib/postgresql/13/main -l /var/log/postgresql/postgresql-13-main.log -s -o -c config_file=“/etc/postgresql/13/main/postgresql.conf” exited with status 1:
  • Jun 01 20:41:25 postgresql@13-main[85963]: 2023-06-01 20:41:25.467 CEST [85968] LOG: invalid value for parameter “lc_messages”: “en_US.UTF-8”
  • Jun 01 20:41:25 postgresql@13-main[85963]: 2023-06-01 20:41:25.467 CEST [85968] LOG: invalid value for parameter “lc_monetary”: “en_US.UTF-8”
  • Jun 01 20:41:25 postgresql@13-main[85963]: 2023-06-01 20:41:25.467 CEST [85968] LOG: invalid value for parameter “lc_numeric”: “en_US.UTF-8”
  • Jun 01 20:41:25 postgresql@13-main[85963]: 2023-06-01 20:41:25.467 CEST [85968] LOG: invalid value for parameter “lc_time”: “en_US.UTF-8”
  • Jun 01 20:41:25 postgresql@13-main[85963]: 2023-06-01 20:41:25.467 CEST [85968] FATAL: configuration file “/etc/postgresql/13/main/postgresql.conf” contains errors
  • Jun 01 20:41:25 postgresql@13-main[85963]: pg_ctl: could not start server
  • Jun 01 20:41:25 postgresql@13-main[85963]: Examine the log output.
  • Jun 01 20:41:25 systemd[1]: postgresql@13-main.service: Can’t open PID file /run/postgresql/13-main.pid (yet?) after start: Operation not permitted
  • Jun 01 20:41:25 systemd[1]: postgresql@13-main.service: Failed with result ‘protocol’.
  • Jun 01 20:41:25 systemd[1]: Failed to start PostgreSQL Cluster 13-main.
  • Jun 01 20:58:09 systemd[1]: Starting PostgreSQL Cluster 13-main…
  • Jun 01 20:58:09 postgresql@13-main[86628]: Error: /usr/lib/postgresql/13/bin/pg_ctl /usr/lib/postgresql/13/bin/pg_ctl start -D /var/lib/postgresql/13/main -l /var/log/postgresql/postgresql-13-main.log -s -o -c config_file=“/etc/postgresql/13/main/postgresql.conf” exited with status 1:
  • Jun 01 20:58:09 postgresql@13-main[86628]: 2023-06-01 20:58:09.420 CEST [86635] LOG: invalid value for parameter “lc_messages”: “en_US.UTF-8”
  • Jun 01 20:58:09 postgresql@13-main[86628]: 2023-06-01 20:58:09.420 CEST [86635] LOG: invalid value for parameter “lc_monetary”: “en_US.UTF-8”
  • Jun 01 20:58:09 postgresql@13-main[86628]: 2023-06-01 20:58:09.420 CEST [86635] LOG: invalid value for parameter “lc_numeric”: “en_US.UTF-8”
  • Jun 01 20:58:09 postgresql@13-main[86628]: 2023-06-01 20:58:09.420 CEST [86635] LOG: invalid value for parameter “lc_time”: “en_US.UTF-8”
  • Jun 01 20:58:09 postgresql@13-main[86628]: 2023-06-01 20:58:09.420 CEST [86635] FATAL: configuration file “/etc/postgresql/13/main/postgresql.conf” contains errors
  • Jun 01 20:58:09 postgresql@13-main[86628]: pg_ctl: could not start server
  • Jun 01 20:58:09 postgresql@13-main[86628]: Examine the log output.
  • Jun 01 20:58:09 systemd[1]: postgresql@13-main.service: Can’t open PID file /run/postgresql/13-main.pid (yet?) after start: Operation not permitted
  • Jun 01 20:58:09 systemd[1]: postgresql@13-main.service: Failed with result ‘protocol’.
  • Jun 01 20:58:09 systemd[1]: Failed to start PostgreSQL Cluster 13-main.

Merci d’avance

Est-ce qu’il y a une histoire particulière avec ton postgresql, genre tu avais désinstallé / résintaller des trucs, ou bien tu avais modifié manuellement la configuration ou un truc du genre

Ceci dit ça semble être lié à des histoires de locales, genre il n’y pas la locale en_US.UTF-8 sur ton système :

Le problème a été corrigé en exécutant
localedef -i en_US -f UTF-8 en_US.UTF-8

J’ai aussi annulé mes modifications sur postgresql.conf

Merci pour ton aide

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.