Announcing E-Maj 5.0.0.

E-Maj 5.0.0 adds the ability for non-superuser roles to install and use the extension, with the set of available features determined by the privileges granted to those roles. It also provides helpers that make it easier to write idempotent administration scripts and to manage E-Maj parameters. The release declares compatibility with PostgreSQL versions 14 through 19, including the newly released PostgreSQL 19. The accompanying Emaj_web client has been updated to take advantage of these new capabilities.

Upgrading to E-Maj 5.0.0 requires replacing the existing extension with the new package from pgxn.org or github.org. Administrators must review and assign appropriate privileges to any non-superuser roles that will interact with E-Maj. Existing administration scripts should be examined to ensure they can benefit from the idempotency helpers, which may involve minor rewrites. Testing with the updated Emaj_web client is recommended to confirm that the web interface works with the new extension version.

E-Maj 5.0.0 will not function on PostgreSQL installations older than version 14 or newer than version 19. If a non-superuser role lacks the specific privilege required for a given E-Maj feature, that feature will be unavailable to that role. The Emaj_web client is only guaranteed to work with E-Maj extension versions from 3.0 up to 5.0, so older web clients may need upgrading. Attempting to use features that depend on superuser-only operations will fail for roles without those privileges.

By allowing non-superuser roles to handle E-Maj tasks, teams can reduce the operational burden on database superusers. The idempotency helpers simplify the creation of repeatable deployment and maintenance scripts, which can improve reliability in automated pipelines. Organizations must still maintain a process for granting and auditing role privileges to prevent unintended access to sensitive E-Maj functions. Overall, the release shifts some administrative work to less privileged accounts while requiring careful privilege management and version compatibility checks.