Jeevan Chalke

Senior Staff SDE, Database Architect, and Manager, EDB

Jeevan is a Senior Staff SDE, Database Architect, and Manager at EDB. He primarily works on Database Server development.

Before EDB, Jeevan was a research intern at Intel India Technologies Pvt Ltd. He joined EDB in 2008, and in his 15+ years of experience with the company, Jeevan has been a zealous contributor as a developer and as a reviewer of a myriad set of patches in the PostgreSQL community. He is mainly involved in developing and committing the features and design for EnterpriseDB's Advanced Server.

Jeevan is an alumnus of IIT Bombay from where he holds a masters degree in Information Technology.

Read Blogs

Postgres Tutorials

Redefining triggers: Compound Triggers in EDB Postgres Advanced Server

Are you bored with writing multiple triggers? Do you want the ability to share details between the various triggers’ timing points for the same table? Let's use the compound triggers feature added in EDB Postgres Advanced Server 12 (EPAS 12).
Postgres Tutorials

Managing Roles with Password Profiles: Part 3

Here in this blog, I’ll explain some new parameters for password profiles like PASSWORD_REUSE_TIME, PASSWORD_REUSE_MAX, and PASSWORD_ALLOW_HASHED (Added in v11). In the end, we will touch upon the DEFAULT profile. PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX To restrict the user from setting a password that is either the same as that of the last few passwords or that has been used too recently...
Postgres Tutorials

Managing Roles with Password Profiles: Part 2

In Part 1, I have explained how FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME can be used to record user logins. In this post, I will explain how to manage a password including its life time, grace time along with enforcing certain rules on the password phrase. PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME PASSWORD_LIFE_TIME specifies the number of days that the current password is valid and usable...
Postgres Tutorials

Managing Roles with Password Profiles: Part 1

What is a Password Profile? Have you seen pop-up messages saying, "You are left with two more attempts" when you enter a wrong password? Also, have you seen a dialog box saying "Account locked due to too many failed logins"? Likewise, you might have also seen the alert to change your password because it is too old. And when you try to change your password, it won't allow you to change it to the...
EDB Labs

How to work with Nested Subprocedures in PostgreSQL

As the name suggests, a nested subprocedure allows us to write a function or procedure nested within another function or procedure. It means a function can have another function within it, just like its own variable. And, as this inner function is part of the outer function, it has no visibility outside the function that encloses it.