The E-Maj team has announced the release of E-Maj 5.0.0, a major update to the PostgreSQL extension that provides fine-grained write logging and time travel on database subsets. This release introduces several significant improvements, including support for non-superuser roles, easier scripting, and compatibility with the latest PostgreSQL versions.
Key changes in E-Maj 5.0.0 include:
- Non-superuser roles can now install and use E-Maj in a database, with available features determined by the privileges granted to the user. This broadens accessibility and allows more flexible permission management.
- Idempotent administration scripts are easier to write, and management of E-Maj parameters has been improved, simplifying automation and configuration.
- PostgreSQL 19 compatibility is added, while maintaining support for PostgreSQL 14 through 19. This ensures that E-Maj works with the latest database releases.
- The Emaj_web client has been enhanced to take advantage of the new features and is compatible with E-Maj extension versions 3.0 to 5.0.
E-Maj is a valuable tool for developers who need to audit changes, implement time-travel queries, or maintain historical data for specific tables. With the new non-superuser support, it becomes easier to integrate into environments with strict security policies, allowing developers to use E-Maj without requiring elevated database privileges. The improved idempotency in scripts also reduces friction in continuous integration and deployment pipelines.
For installation, the core extension is available on PGXN and GitHub, while the Emaj_web client is also hosted on GitHub. Full documentation is available online. This release underscores the project's commitment to keeping pace with PostgreSQL evolution and addressing real-world developer needs.
Source: https://www.postgresql.org/about/news/announcing-e-maj-500-3353/