PostgreSQL providing the option to configure password expiry for users.
The following query can be used to configure password expiry.
>ALTER USER NAME VALID UNTIL 'DATE';
Where NAME and DATE need to be replaced with the username and expiry date respectively.
If its required to configure the password to never expire, the following query can be used.
>ALTER USER NAME VALID UNTIL 'infinity';
Where NAME need to be replaced with the username.
Please note that the same option can be used along with the CREATE query also.