Rotating PostgreSQL Passwords with no downtime

Examining a PostgreSQL with psql or pgcli