Message-ID: <786b70c5-ee75-4450-84e7-936a20de63b9@gmail.com>
Date: Wed, 7 Jan 2026 15:56:32 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Pasword expiration warning
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>
References: <129bcfbf-47a6-e58a-190a-62fc21a17d03@migops.com>
 <3046422.1637337334@sss.pgh.pa.us>
 <a776f2d0-7ef8-f734-48b7-2aa383f41b2b@migops.com>
 <C7B3C461-2A44-4A73-B71F-933AD2DC3C6A@amazon.com>
 <3ea14054-af0c-3f21-0ced-04c896438bdc@dunslane.net>
 <08e09a01-5762-3b2e-1fa7-513478ab7394@migops.com>
 <e16e7928-a51e-47d9-94fa-f5b50cab58ce@darold.net>
 <MEAPR01MB3031B4F594E62343BF1F8EDBB684A@MEAPR01MB3031.ausprd01.prod.outlook.com>
 <tencent_8C7890411E85257F512EFE4F0DD00EE29806@qq.com>
Content-Language: en-US
From: Gilles Darold <gillesdarold@gmail.com>
In-Reply-To: <tencent_8C7890411E85257F512EFE4F0DD00EE29806@qq.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/786b70c5-ee75-4450-84e7-936a20de63b9%40gmail.com>
Precedence: bulk

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.