Re: Pasword expiration warning

Gilles Darold <gillesdarold@gmail.com>

From: Gilles Darold <gillesdarold@gmail.com>
To: songjinzhou <tsinghualucky912@foxmail.com>, Japin Li <japinli@hotmail.com>, Gilles Darold <gilles@darold.net>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Andrew Dunstan <andrew@dunslane.net>, "Bossart, Nathan" <bossartn@amazon.com>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2026-01-07T14:56:32Z
Lists: pgsql-hackers
Le 07/01/2026 à 09:37, songjinzhou a écrit :
> Hello fellow hackers, I've refined the print information based on the japin code above, but otherwise remained unchanged. The result is as follows:
>
> [postgres@localhost:~/test/bin]$ ./psql -p 5432 -U test_user2 -d postgres
> Password for user test_user2:
> 2026-01-07 00:28:25.999 PST [82198] WARNING:  your password will expire in 7 hours and 31 minutes
> WARNING:  your password will expire in 7 hours and 31 minutes
> psql (19devel)
> Type "help" for help.
>
>
> postgres=> \q
> [postgres@localhost:~/test/bin]$ ./psql -p 5432 -U test_user3 -d postgres
> Password for user test_user3:
> 2026-01-07 00:28:33.998 PST [82282] WARNING:  your password will expire in 2 days and 7 hours
> WARNING:  your password will expire in 2 days and 7 hours
> psql (19devel)
> Type "help" for help.
>
>
> postgres=> \q
> [postgres@localhost:~/test/bin]$
>
>
> Thanks
> 	
> songjinzhou
> tsinghualucky912@foxmail.com
>
I'm not in favor of a higher granularity like explained in my previous 
answer, I don't see it as a countdown to the second. But why not if 
there's more people in favor of a more detailed remaining time, your 
improvement will be welcome.





Commits

  1. Add password expiration warnings.