Re: ROLE VALID UNTIL timezone?

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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@xxxxxxxxxxx