This way you can also force a certain password expiry date (PostgreSQL does not have a password life time).
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных