PgManage is a Postgres centered multi-database management Open Source project. It is a fork of the previously well received project OmniDB that had been abandoned. Command Prompt has taken the helm of this project to ensure a quality project focused on the Management of PostgreSQL and related technologies.
- Source: https://github.com/commandprompt/pgmanage
- Website and Binaries: https://commandprompt.com/products/pgmanage/
- Full Documentation: https://pgmanage.readthedocs.io/en/latest/
- Community: https://discord.gg/FvweAhhUeu
Major Changes from OmniDB
New features:
- new connection management UI
- added support for postgres server configuration management
- new explain/analyze UI powered by pev2, including pev2 dark theme support
- connection credential encryption
- backported support for monitoring data-grid-based monitoring widgets
- backported pie charts widgets for numbackends and database sizes
- added password strength validation for user and master passwords
- PostgreSQL 9.6, 10, 11, 12, 13, 14 and 15 support
Major Bugs fixed:
- fixed data export to csv/xls format in the desktop version of the app
- added superuser permission check on all user management APIs
- extra validations added to prevent creation of unnamed connection groups
- fixed external links not working in the desktop variant of the app
- fixed postgres special commands on postgresql versions 12 and higher
- fixed broken postgres documentation links available in database tree view menus
- made all web/cdn app dependencies local so pgmanage can work properly without an internet connection
UI/UX Improvements:
- reorganized connection management menus in the left menu bar
- fixed DDL tab auto resizing
- the top-right utilities menu now expands on click instead of mouse-hover
- added ddl/properties tab resize limits to prevent it from becoming impossible to grab/resize back
- unified tooltip appearance throughout the whole app
- unified pictogram look and feel throughout the whole app
- improved database tree view navigation by adding smooth scroll to the newly expanded tree node. previously when some tree view node was expanded it jumped out of sight
- improved data grid/table readability
- improved database entity tree view readability
- fixed date formatting in sql command history grid
- fixed date formatting in db console command history grid
- proper styling for dialog primary and secondary buttons. the secondary buttons in forms and dialogs were previously looked disabled/grayed-out which was confusing.
- the autocommit checkbox on query tab now stays visible despite of application window size removed the option to make connections public in desktop variant of the app (which has only one user so shared/public connections make no sense)
Other changes
- application data directory and db/log file naming was changed from omnidb* to pgmanage*.