<div>
You can alter the role to set the 'valid until':<br />
<a href="https://www.postgresql.org/docs/13/sql-alterrole.html" rel="ugc">https://www.postgresql.org/docs/13/sql-alterrole.html</a><br />
<br />
I don't know of a build in way to set a grace/reminder period nor do I know a way to have the valid until' reset for another 60 days.<br />
<br />
Seem there are a few tricks using triggers on the web if you look around a little.
</div>


You can alter the role to set the 'valid until':
https://www.postgresql.org/docs/13/sql-alterrole.html [https://www.postgresql.org/docs/13/sql-alterrole.html]

I don't know of a build in way to set a grace/reminder period nor do I know a way to have the valid until' reset for another 60 days.

Seem there are a few tricks using triggers on the web if you look around a little.

pvsbandi

<div>
<div class="content wysiwyg-content fr-view">
<p>Greetings,&nbsp;</p><p>&nbsp; &nbsp; &nbsp; &nbsp;We are on Postgres 13.4 on AWS RDS.</p><p>Is there a way to force users to change their password after 60 days.</p><p><br></p>
</div>
</div>



Greetings, 
       We are on Postgres 13.4 on AWS RDS.
Is there a way to force users to change their password after 60 days.

Postgres - force the users to change password periodically

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.