You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by kuien <gi...@git.apache.org> on 2017/10/19 09:42:32 UTC
[GitHub] incubator-hawq issue #1292: HAWQ-1532. recognize timezone 'CST' correctly in...
Github user kuien commented on the issue:
https://github.com/apache/incubator-hawq/pull/1292
On my redhat 7 server, it works like following:
psql (8.2.15)
Type "help" for help.
postgres=# show timezone_abbreviations;
timezone_abbreviations
------------------------
Default
(1 row)
postgres=# select * from hawq_toolkit.hawq_log_master_concise limit 1;
logtime | logdatabase | logsession | logcmdcount | logseverity |
logmessage
-------------------------------+-------------+------------+-------------+-------------+--------
---------------------------------
2017-10-20 06:44:15.209736+08 | template1 | | | FATAL | the dat
abase system is in recovery mode
(1 row)
postgres=# set timezone_abbreviations to 'Asia';
SET
postgres=# select * from hawq_toolkit.hawq_log_master_concise limit 1;
logtime | logdatabase | logsession | logcmdcount | logseverity |
logmessage
-------------------------------+-------------+------------+-------------+-------------+--------
---------------------------------
2017-10-19 16:44:15.209736+08 | template1 | | | FATAL | the dat
abase system is in recovery mode
(1 row)
---