All about PostgreSQL Security.
Presented by:
Ibrar Ahmed
Ibrar Ahmed is a seasoned Principal Engineer at pgEdge, bringing a wealth of experience in software design and development to the world of open source. With a strong background in system-level embedded development, Ibrar has honed his expertise over the years with renowned PostgreSQL companies such as EnterpriseDB, Percona, and Bitnine.
Having embarked on his journey with PostgreSQL since 2006, Ibrar has become intricately involved in the core engine of PostgreSQL, making significant contributions to its evolution. From spearheading major performance enhancements to refining various PostgreSQL modules, his dedication to advancing the platform has left an indelible mark on the PostgreSQL community.
Beyond PostgreSQL, Ibrar's proficiency extends to a multitude of databases, including MySQL, Oracle, and cutting-edge NoSQL technologies like MongoDB and Hadoop. His expertise isn't confined solely to databases; he possesses adeptness with related tools such as Hive, HBase, and Spark, seamlessly integrating them with PostgreSQL to unlock new possibilities in data management and analytics.
Recognized for his depth of knowledge and insight, Ibrar has authored multiple authoritative books on PostgreSQL and is a highly regarded blogger within the PostgreSQL community, sharing valuable insights and best practices with a global audience. With a passion for innovation and a commitment to excellence, Ibrar Ahmed continues to drive forward the boundaries of database technology, shaping the future of data management in the digital age. He gave more than fifteen PostgreSQL talks in the last one year in various parts of the World (PostgreConf-EU, PostgreConf-ASIA, PostgreConf-NY, Percona Lives, etc ). He also authored multiple books on PostgreSQL.
No video of the event yet, sorry!
PostgreSQL provides different levels of security. This talk will cover all the available security techniques used in PostgreSQL 13. We’ll look at client-side security (LibPq, JDBC) through to server-side security. It will cover all supported authentication methods and the pros and cons of all these methods. Some of the key features of the talk are: - Introduction to Cryptography - SSL, TLS, GSSAPI, and OpenSSL - Client-Side Encryption - Securing Authentication - Securing Data on the disk - Securing Backup & Basebackup - Securing Replication - Database Roles and Privileges It’s important to be familiar with all the security levels such as (1)network-level security (2) on-disk security (3) row-level, (4), and column level security. The talk will cover all the aspects with some real-life use cases and examples.
- Date:
- 2020 November 20 13:30 CST
- Duration:
- 40 min
- Room:
- Virtual - English Sub-Conference A
- Conference:
- CHINA 2020 And PGConf.Asia 2020
- Language:
- Track:
- Security
- Difficulty:
- Medium