PostgreSQL 17's Login Event Triggers: A Developer's Toolkit for Enhanced Security
Presented by:
Bharath Kumar Pammi Ramesh
Chethan Gangadharaiah is a seasoned and highly skilled Lead Database Consultant working in AWS Professional services with a passion for working on different database technologies. With over 15 years of experience in the field, Chethan has established himself as a trusted advisor and problem solver in the world of database management.
Checkout the slides
PostgreSQL 17 *introduces a powerful new feature: *Login Event Triggers.
This capability allows developers to execute custom code when users connect to a database, opening up new possibilities for** security, auditing, and session management. **
Talk will cover 1.Login Event Triggers can be used to implement sophisticated access controls, log connection attempts, initialize session data, or dynamically assign roles based on connection time or other factors. 2. Explore the syntax, use cases, and best practices for implementing Login Event Triggers, empowering developers to enhance database security and functionality in PostgreSQL 17.
Key takeaways 1.Developers will gain knowledge on how to leverage this feature to enhance both database security and functionality in PostgreSQL 17.
- Date:
- 2025 March 6 - 14:00
- Duration:
- 45 min
- Room:
- Jupiter
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Database Engine Developers
- Difficulty:
- Medium
- Graph databases, PostgreSQL and SQL/PGQ
- Start Time:
- 2025 March 6 14:00
- Room:
- Grand Ballroom 2
- pgBackRest: Elevating PostgreSQL Backup Game
- Start Time:
- 2025 March 6 14:00
- Room:
- Grand Ballroom 1
- Unleashing the Power of Azure Database for PostgreSQL Flexible Server
- Start Time:
- 2025 March 6 14:00
- Room:
- Neptune