log_timezone = UTC (charm default) is invalid on xenial
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PostgreSQL Charm |
Fix Released
|
High
|
Stuart Bishop | ||
postgresql (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
the log_timezone = UTC which worked on precise/trusty causes an error...
http://
it is in /usr/share/
either way I set it to GMT which worked fine.
my workaround
ubuntu@
listen_
ssl=true
log_checkpoints
log_connections
log_disconnecti
log_autovacuum_
log_line_prefix='%t [%p]: [%l-1] db=%d,user=%u '
archive_mode=on
archive_
hot_standby=true
max_wal_senders=80
# max_wal_
# wal_level=
# shared_
# effective_
default_
from_collapse_
join_collapse_
wal_buffers=-1
checkpoint_
password_
max_connections=100
log_timezone = GMT"
tags: | added: oil |
Changed in postgresql-charm: | |
status: | New → Triaged |
importance: | Undecided → High |
Yep, its the symlink thing..., dunno why postgres can't deal with them, seems very strange.
precise/trusty
GMT -> Greenwich
Zulu -> UTC
xenial
Greenwich -> GMT
UTC -> Zulu
So there is neither default which will work across the series... bummer.
http://<email address hidden> says it should default to UTC if not specified, but that's for internal db timestamps, not sure for logging.
http:// stackoverflow. com/questions/ 26049242/ postgresql- error-timezone- directory- stack-overflow also mentions to check whether it was compiled with the --with- system- tzdata flag, but dunno what the debbuild does.