Re: ROLE VALID UNTIL timezone?

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.klaver@aklaver.com