Re: ROLE VALID UNTIL timezone?

[Adrian Klaver]

On 11/27/19 2:19 PM, Ron wrote:
Hi,
In 9.6, does it default to UTC, the postgresql.conf timezone value 
(US/Eastern) value or to local system time?



test_(postgres)# show timezone;
  TimeZone
------------
 US/Pacific

test_(postgres)# create role ts_test valid until '12/31/2020';
CREATE ROLE

ts_test        | Cannot login 
  +| {}
                | Password valid until 2020-12-31 00:00:00-08 
     |

Best guess it operates like if specifying a value for a timestamptz field.

--
Adrian Klaver
adrian.kla...@aklaver.com