Postgres Pro
Downloads
Home   >   mailing lists

BUG #16118: subsequent to Postgres server 12.1 patch, database won't start - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16118: subsequent to Postgres server 12.1 patch, database won't start
Date
Msg-id 16118-ef1e45e342c52416@postgresql.org
Whole thread Raw
Responses Re: BUG #16118: subsequent to Postgres server 12.1 patch, database won't start  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      16118
Logged by:          dan ducey
Email address:      ars.na6mg@gmail.com
PostgreSQL version: 12.1
Operating system:   FreeBSD 12.1
Description:

$ pg_ctl -D data12 start
waiting for server to start....2019-11-15 19:02:46.630 GMT [77092] LOG:
invalid value for parameter "log_timezone": "US/Pacific"
2019-11-15 19:02:46.630 GMT [77092] LOG:  invalid value for parameter
"TimeZone": "US/Pacific"
2019-11-15 19:02:46.630 GMT [77092] FATAL:  configuration file
"/var/db/postgres/data12/postgresql.conf" contains errors
 stopped waiting
pg_ctl: could not start server
Examine the log output.

Edited postgresql.conf and commented-out: log_timezone = 'US/Pacific' and
timezone = 'US/Pacific' to enable successful startup.  The postgresql.conf
file worked with postgresql-server-12.0

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: incorrect pg_dump output due to not handling dropped roles correctly
Next
From: Tom Lane
Date:
Subject: Re: BUG #16118: subsequent to Postgres server 12.1 patch, database won't start