timezone_abbreviations
Sets the collection of time zone abbreviations that will be accepted by the server for date time input. The default is Default, which is a collection that works in most of the world. Australia and India, and other collections can be defined for a particular installation. Possible values are names of configuration files stored in $GPHOME/share/postgresql/timezonesets/.
To configure Greenplum Database to use a custom collection of timezones, copy the file that contains the timezone definitions to the directory $GPHOME/share/postgresql/timezonesets/ on the Greenplum Database master and segment hosts. Then set value of the server configuration parameter timezone_abbreviations to the file. For example, to use a file custom that contains the default timezones and the WIB (Waktu Indonesia Barat) timezone.
- Copy the file Default from the directory $GPHOME/share/postgresql/timezonesets/ the file custom. Add the WIB timezone information from the file Asia.txt to the custom.
- Copy the file custom to the directory $GPHOME/share/postgresql/timezonesets/ on the Greenplum Database master and segment hosts.
- Set value of the server configuration parameter timezone_abbreviations to custom.
- Reload the server configuration file (gpstop -u).
Value Range | Default | Set Classifications |
---|---|---|
string | Default | master session reload |