Re: "localtime" value in TimeZone

2019-07-25 Thread Tom Lane
Shay Rojansky writes: > I followed the conversations you linked to, and disagreements seem to be > mostly about other aspects of timezone selection. Does it make sense to > have a limited, restricted conversation specifically about avoiding > "localtime"? I've tried to kick-start the other thread

Re: "localtime" value in TimeZone

2019-07-25 Thread Shay Rojansky
> Yeah, this is something that some tzdb packagers do --- they put a > "localtime" file into /usr/share/zoneinfo that is a symlink or hard link > to the active zone file, and then initdb tends to seize on that as being > the shortest available spelling of the active zone. I see, I wasn't aware tha

Re: "localtime" value in TimeZone

2019-07-24 Thread Tom Lane
Shay Rojansky writes: > In (certain) out-of-the-box PostgreSQL installations, the timezone GUC is > set to "localtime", which seems to mean to query the OS for the value. > Unless I'm mistaken, the issue with this is that it doesn't allow clients > inspecting the TimeZone GUC to actually know what

"localtime" value in TimeZone

2019-07-24 Thread Shay Rojansky
Greetings everyone. In (certain) out-of-the-box PostgreSQL installations, the timezone GUC is set to "localtime", which seems to mean to query the OS for the value. Unless I'm mistaken, the issue with this is that it doesn't allow clients inspecting the TimeZone GUC to actually know what timezone