On 5/18/24 03:09, Rama Krishnan wrote:
Reply to list also.
Ccing list
Hi Adrian,
I have modified the pg_hba entry from trust to md5 like below
```
local all all md5
That would be the issue. trust ignores the password check.
```
When i ha
On 5/18/24 02:37, Rama Krishnan wrote:
Reply to list also.
Ccing list.
Please find the details below
```
postgres=# \du
List of roles
Role name | Attributes
+
p
Hi,
What is the outcome of this query for the specified user? Does the database
contain a value in the rolvaliduntil column?
SELECT rolname, rolvaliduntil FROM pg_authid;
Regards,
M.Imtiaz
On Tue, 14 May 2024 at 20:45, Tom Lane wrote:
> Adrian Klaver writes:
> > On 5/14/24 00:57, Rama Krishnan
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" parameter just for identification purposes,
>> indicatin
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 database. Is this a bug,
or is the "valid u
