pgconfig / api

PGConfig.org API v2
MIT License
48 stars 9 forks source link

log_format error value for stderr #14

Closed iroot-technology closed 8 months ago

iroot-technology commented 1 year ago

This code need append a 'r' to 'stderr' value in log_format

{Format: "string", Name: "log_destination", Value: "stder"}

PostgreSQL doesn't up.

Jul 18 11:28:04 postgresql@15-main[1137]: Error: /usr/lib/postgresql/15/bin/pg_ctl /usr/lib/postgresql/15/bin/pg_ctl start -D /var/lib/postgresql/15/main -l /var/log/postgresql/postgresql-15-main.log -s -o -c config_file="/etc/postgresql/> Jul 18 11:28:04 postgresql@15-main[1137]: 2023-07-18 11:28:04.786 UTC [1143] LOG: invalid value for parameter "log_destination": "stder" Jul 18 11:28:04 postgresql@15-main[1137]: 2023-07-18 11:28:04.786 UTC [1143] DETAIL: Unrecognized key word: "stder". Jul 18 11:28:04 postgresql@15-main[1137]: 2023-07-18 11:28:04 UTC [1143]: [3-1] user=,db=,app=,client= FATAL: configuration file "/var/lib/postgresql/15/main/postgresql.auto.conf" contains errors Jul 18 11:28:04 postgresql@15-main[1137]: pg_ctl: could not start server

After changed to 'stderr' works fine!