Video: PostgreSQL Security Features - Password Profiles

Marc Linster January 5, 2021

Video: PostgreSQL Security Features - Password Profiles

A password profile is a named set of password attributes that allow a DBA to easily manage a group of Postgres roles (or users) that share comparable password requirements. Each profile can be associated with one or more users. When a user connects to the server, the server enforces the profile that is associated with the login role. 

Profiles can be used for several important security best practices, including:

  • specifying the number of allowable failed login attempts. 
  • locking an account due to excessive failed login attempts.
  • marking a password for expiration.
  • defining a grace period after a password expiration.
  • defining rules for password complexity, and 
  • defining rules that limit password reuse. 

Watch the video below to learn more!

You can download our whitepaper here to read more about PostgreSQL security best practices.

Marc LinsterChief Technology Officer

Marc Linster, Ph.D., is EDB’s Chief Technology Officer and leads EDB’s engineering divisions and product development groups. Marc is committed to EDB being an accelerator to providing architectural “know how” to help customers take advantage of Postgres without significant risk and cost. Marc believes that although new customer adoption of open source is easier than the experience of purchasing proprietary options, tools are still incredibly important, and EDB’s professional services practices provides them. Marc has an extensive background in engineering, technology and logistics with 20 years of management experience. Before joining EDB, Marc spent four years at Polycom, the leading maker of video communications equipment, where most recently he was a Senior Director, Engineering for Cloud and Hosted Solutions. Before Polycom, Marc was Co-founder and President of TriPoint Interactive, a global supply chain consulting and systems integration company. He spent six years at Avicon Group, first as CTO and then as Vice President of Operations. Marc is an avid equestrian. Marc holds a Ph.D. (Dr. rer. nat) in Computer Sciences from the University of Kaiserslautern in Germany.