As above – Are there any solutions in/for postgres that allow for similar functionality to oracle’s password rollover feature, where a user can have two active passwords? We are trying to implement an automatic password rotation feature, and our apps are not currently capable of automatically refreshing the credentials immediately upon connection failure.

At this time updating the applications themselves to force a refresh on connection failure is not an option. Apps run on AWS Lambda, creating datasources on a cold start. We do not want to eliminate the caching of the credentials for latency reasons