FW_PostgreSQL Troubleshooting

Log excerpt:

2023-11-15 07:31:18.955 UTC [1] LOG:  invalid value for parameter "lc_monetary": "en_US.utf8"
2023-11-15 07:31:18.956 UTC [1] LOG:  invalid value for parameter "lc_numeric": "en_US.utf8"
2023-11-15 07:31:18.956 UTC [1] LOG:  invalid value for parameter "lc_time": "en_US.utf8"
2023-11-15 07:31:18.956 UTC [1] FATAL:  configuration file "/var/lib/postgresql/data/postgresql.conf" contains errors
PostgreSQL Database directory appears to contain a database; Skipping initialization

Fix locales

docker exec -it -u 0 FW_PostgreSQL /bin/bash
dpkg-reconfigure locales

Pick the correct locale (en_US.UTF-8)

  • fw_postgresql.txt
  • Last modified: 2023/11/15 15:55
  • by admin
  • Currently locked by: 172.18.0.1