Guy is technical lead at Zebanza, a company renowned for its innovative approach to Open-Source database management. With many years of experience with different database technologies and best practices, Guy consistently addresses issues in a pragmatic and practical manner. His knowledge spans across various database technologies, including Oracle, MySQL, MariaDB and his favorite … PostgreSQL. At Zebanza, Guy is known for his passion for Open-Source solutions and his commitment to helping customers navigate complex data challenges. He has played a crucial role in numerous projects, ensuring that database systems are not only secure but also optimized for performance and reliability. Guy's dedication to continuous learning and improvement is evident in his work. He regularly participates in community events and shares his knowledge through blogs and presentations.
This session will outline and explain various Mechanisms and Best Practices for a Secure PostgreSQL Environment.
• Standards & Regulations
• Overview
• • NIS2 more in detail
General Security Recommendations
• OS & DB Software security patches
Database Security
• Define line for your data
• • Network/Connectivity
• • Vulnerability
• • Security Levels
• • Authentication/Access
• Connection Pooling
• • pgBouncer / pgPool
• PostgreSQL
• • Structure
• • Databases Security
• • • Roles
• • • Row-Level Security
• • • Column-Level Privileges
• • • Function Security
• • • Data Encryption
• • Auditing
• • Backup & Recovery
• • Monitoring & Health Check