have tired with postgres user I am able to connect
Which is expected as postgres does not have a 'valid until' restriction.
[postgres@postgres16 data]$ psql -U postgres -d postgres
Password for user postgres:
psql (16.2)
Type "help" for hel
+
pgbackrest | Replication
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS
test | Password valid until 2023-05-13 00:00:00+00
user_name | Password valid until 2024-05-13 00:00:00+00
postgres=# show timezone;
TimeZone
--
UTC
(1 row)
postgres=# select
:57, Rama Krishnan wrote:
> >> I recently set a user's password validity to "2024-05-13", but despite
> >> this, the user is still able to connect to the database. Is this a bug,
> >> or is the "valid until" parameter just for identification purposes,
Adrian Klaver writes:
> On 5/14/24 00:57, Rama Krishnan wrote:
>> I recently set a user's password validity to "2024-05-13", but despite
>> this, the user is still able to connect to the database. Is this a bug,
>> or is the "valid until&qu
On 5/14/24 00:57, Rama Krishnan wrote:
Hi team,
I have a question about the "valid until" parameter in the "create role"
command.
I recently set a user's password validity to "2024-05-13", but despite
this, the user is still able to connect to the databas
Hi team,
I have a question about the "valid until" parameter in the "create role"
command.
I recently set a user's password validity to "2024-05-13", but despite
this, the user is still able to connect to the database. Is this a bug, or
is the "valid
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.
Decided to see if guess was correct:
https://git.post
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
Hi,
In 9.6, does it default to UTC, the postgresql.conf timezone value
(US/Eastern) value or to local system time?
--
Angular momentum makes the world go 'round.
