Postgres Pro
Downloads
Home   >   mailing lists

Re: ROLE VALID UNTIL timezone? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: ROLE VALID UNTIL timezone?
Date
Msg-id 4375fad2-334f-3d9a-6b2c-ba0e4f337601@aklaver.com
Whole thread Raw
In response to ROLE VALID UNTIL timezone?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: ROLE VALID UNTIL timezone?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ron
Date:
Subject: ROLE VALID UNTIL timezone?
Next
From: Justin
Date:
Subject: Re: Install different directory issues