Postgres Pro
Downloads
Home   >   mailing lists

TimeZone parameter in postgresql.conf - Mailing list pgsql-novice

From Majid Azimi
Subject TimeZone parameter in postgresql.conf
Date
Msg-id CADOhCmuhk+bWxTcMe2AAyYbnZXia-P+oF9dd0y-y_5OCedCVRQ@mail.gmail.com
Whole thread Raw
Responses Re: TimeZone parameter in postgresql.conf
Re: TimeZone parameter in postgresql.conf
List pgsql-novice
Tree view

postgresql documentation says:

All timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone specified by the timezone configuration parameter before being displayed to the client.

timezone parameter is a session parameter. When all TIMESTAMP WITH TIME ZONEs will be stored as UTC and the client connection will specify the session timezone, then what is the benefit of setting TimeZone parameter in postgresql.conf?

pgsql-novice by date:

Previous
From: lazyPGDBA
Date:
Subject: pg_dump error on hot standy db (msg or pg_toast missing a chunk number).
Next
From: Steve Crawford
Date:
Subject: Re: TimeZone parameter in postgresql.conf