Release Notes
Track the evolution of PostgresCompare with detailed release notes and version history.
Version 1.2.0
Released March 23rd, 2026
New Features
- pg_dump / SQL file import — Compare one or both sides of a comparison against a pg_dump file or folder instead of a live database connection. PostgresCompare accepts plain SQL pg_dump output and binary pg_dump format (automatically converted via
pg_restoreif it is on your PATH). You can also point to a folder containing multiple SQL files. This is useful for auditing schema definitions stored in version control, comparing a snapshot against a live database, or working in environments where a direct connection is not available - Comparison options saved per result — The ignore flags, object type filters, name filters, and pre/post deploy script settings that were active when a comparison ran are now stored with the result. Click the info icon next to the Re-run comparison button to see exactly which options produced a given result
Improvements
- History viewer timeline — The schema history view has been redesigned as a vertical timeline with colour-coded indicator dots, relative timestamps (e.g. "2 hours ago"), and automatic selection of the most recent entry. The Monaco diff editor now shows the correct direction (older version on the left, newer on the right) and labels each side with its date. For objects that were created or deleted, a single editor with a contextual banner is shown instead of a blank diff panel
- Changes tab in history viewer — A Changes tab alongside the diff panel gives a plain-English description of what changed for each object between the two selected history entries
- Column reorder migration — PostgresCompare now detects when table columns have changed position and generates a safe migration using CREATE TABLE / INSERT INTO / DROP / RENAME with full constraint reconstruction (primary keys, unique constraints, check constraints, and foreign keys)
- Column scale detection — Scale differences in numeric columns are now detected and generate
ALTER COLUMN TYPEstatements - Scrollable deployment progress log — The deployment progress log in the Run Script modal is now a scrollable, multi-line display that accumulates
RAISE NOTICEoutput as each statement executes. The progress logging preference is saved per project in local storage
Version 1.1.107
Released March 16th, 2026
New Features
- Changes tab — A new Changes tab sits alongside the SQL diff view and shows a human-readable summary of what changed: which columns were added or removed, which constraints were modified, and so on. Switch between the Changes tab and the SQL view depending on whether you want a plain-English summary or the full DDL comparison
- Deployment progress logging — Generated scripts now include timestamped
RAISE NOTICEstatements after each DDL change (e.g.[✓] 14:23:05 | public.users | alter table) and a[>>] Migration complete at …notice at the end. Progress output is visible in any client — psql, DataGrip, or similar — and NOTICE output is captured and displayed in the in-app deployment modal. The toggle is on by default and can be disabled from the script toolbar; notices follow statement selection so deselecting a change also removes its notice - Name filters — Each object type in the comparison list now has its own name filter. Type to show only objects whose names match within that type — for example, showing only tables containing "order" — without affecting other object types in the list
- Create database — PostgresCompare can now create a new PostgreSQL database directly from within the app. Open an environment and click Create database to create a database on that server without leaving the app
Improvements
- Diff editor: navigator and word wrap — The SQL diff editor now includes a navigator panel listing each changed section for quick jumping, and a word wrap toggle in the toolbar for long lines such as function bodies
- Cleaner object list — Value columns have been removed from the comparison list and the schema column is collapsed by default, giving more room for object names and making the list easier to scan
Version 1.1.106
Released March 8th, 2026
New Features
- Star / favourite comparisons — Mark comparisons as favourites by clicking the star icon on a comparison tile. Starred comparisons show an amber star and can be filtered to the top of the list with a single click on the toolbar toggle
- Deploy confirmation dialog — Clicking "Run script…" now shows a confirmation modal displaying the target connection and database before executing. Destructive statements are highlighted in red and warnings in amber, and the Run button itself turns red when the script contains destructive changes
- Export reports — Export comparison results in multiple formats: Excel (with a doughnut-chart summary sheet), HTML (with clickable status filter pills and sortable columns), PDF, JSON, Markdown, and CSV. Filenames default to the database names and date (e.g. devDb_vs_prodDb_2026-03-08.xlsx). A companion
.schema.jsonis written alongside JSON exports for CI/CD validation. The export options modal defaults "Identical" objects to unchecked
Improvements
- Pre/post deploy scripts in statement list — Pre- and post-deploy scripts now appear as entries in the deployment statement list with include/exclude checkboxes. Section headers and dependency comments are suppressed automatically when their associated change is excluded, and the deployment execution matches exactly what the list shows
- Faster script generation — The dependency-ordering algorithm has been replaced with Kahn's O(V+E) topological sort, eliminating the previous O(n³) approach. The script page now shows shimmer skeleton loaders on both panels while the draft is being generated
- Cleaner script section headers — Drop operations now use the same "Type name" heading format as creates. Indexes, triggers, and policies each get their own per-item section header rather than being grouped under a parent table heading
Bug Fixes
- Fixed "Select all" / "Deselect all" not toggling pre/post deploy scripts
- Fixed syntax errors when a column, index, or other identifier is named a PostgreSQL reserved keyword (e.g.
order) - Fixed aggregate scripting to include the argument type in
CREATE AGGREGATEandALTER AGGREGATEstatements - Fixed deployment script ordering for materialized views, corrected index expression parsing for multi-argument expressions such as
COALESCE(a, b), and fixedcharacter[]function arguments being rendered asharacter [] - Fixed the Monaco diff editor failing to initialise in the comparison history viewer
- Fixed a false "stale comparison" warning appearing when it should not
Version 1.1.105
Released March 2nd, 2026
New Features
- Re-run comparison — Run a fresh comparison directly from the comparison detail view without navigating away. Results stream in live, and the previous comparison is preserved in the history list
- Comparison history swimlane view — Track how your schema has changed over time with a new grouped history view. Objects are organised by change category (Fixed, Regressed, New, Removed, Changed, Unchanged) with collapsible sections, count badges, and colour-coded borders
- Related object navigation — When viewing a difference, clickable chips appear showing dependencies ("Depends on") and reverse references ("Referenced by") for the selected object, colour-coded by their comparison status. Clicking a chip jumps straight to that object in the list
- SQL line highlighting — Clicking a child row (column, constraint, or property) in the differences list now scrolls the diff editor to and highlights the exact line of SQL for that sub-object
- Auto-fetch databases and schemas — Databases load automatically when a connection is selected, and schemas load when a database is chosen. The environment dropdowns have been replaced with styled Bootstrap menus matching the rest of the app
- Delete comparison confirmation — Deleting a comparison now shows a confirmation dialog. The tile fades out on confirm to give clear visual feedback
Improvements
- Redesigned Overview tab — Replaced the text summary with five clickable stat cards (Total, Identical, Different, New, Dropped). Chart segments are now interactive — clicking navigates to the Objects tab with the relevant filter applied. The tab has been renamed from "Summary" to "Overview"
- Save script respects your selection — The saved .sql file now matches exactly what would be deployed, correctly applying any statements you have deselected
- Faster startup — The app loads noticeably faster through parallel API calls on launch and deferred loading of the Monaco editor (~2.5 MB removed from the critical path)
Bug Fixes
- Fixed deployment executing the wrong statements when some script entries were deselected
- Fixed save script failing silently on API error — an error dialog is now shown
- Fixed the comparison toolbar scrolling out of view
- Fixed the licence modal layout where the machine ID was overlapping the activation status indicator
Version 1.1.104
Released February 23rd, 2026
New Features
- Pre/post deploy scripts — Add custom SQL that runs before or after the generated deployment script, editable directly in the app using Monaco editor
- Global search — Search across projects, environments, and comparison objects from anywhere in the app
- Keyboard navigation in the difference list — Use arrow keys to move through differences without the mouse
- Dependency cascade selection — Selecting a script statement automatically selects its dependencies
Improvements
- Redesigned comparison card with progress bars and a breakdown of difference types
Bug Fixes
- Fixed comparison panel overflowing the bottom of the screen
- Fixed arrow key expand/collapse for tree rows
- Fixed auto-updater crash on update errors
Version 1.1.103
Released February 18th, 2026
New Features
- Destructive change warnings — Deployment scripts now highlight dangerous statements before you run them. Statements are classified as Destructive (e.g. DROP TABLE, DROP COLUMN) or Warning (e.g. DROP FUNCTION, DROP VIEW), with colored row styling, warning icons, summary banners, and glyph margin indicators in the SQL editor
- Hover to preview differences — Hovering over a row in the script statement list shows a floating diff popover so you can inspect the before/after SQL without leaving the screen
- Deployment script section headers — Generated scripts now group statements by object type (Tables, Views, Types, Sequences, Column Changes, Constraints, Indexes, Functions, Materialized Views, Triggers, Policies, Privileges, Drop Objects). Section headers are clickable in the statement list, and a script header shows the version, source/target database names, and timestamps. Dependency comments explain ordering for dependency-sorted objects
Bug Fixes
- Select all now only toggles rows visible after filtering, and the header checkbox accurately reflects the current selection state
- Filter dropdowns no longer lose their selected value on re-render
- Filter counts exclude section header rows
Version 1.1.102
Released February 7th, 2026
New Features
- Added option to ignore column statistics differences - useful when source and target databases have different ANALYZE settings
Version 1.1.101
Released January 18th, 2026
Bug Fixes
- Fixed PostgreSQL 18 compatibility by removing deprecated attcacheoff column from queries
- Fixed compatibility issue with PostgreSQL 17's new MAINTAIN privilege
Version 1.1.100
Released July 1st, 2024
Improvements
- Removed heading from difference viewer for cleaner UI
Version 1.1.99
Released June 24th, 2024
Bug Fixes
- Fixed bug where PostgresCompare was not ignoring tablespace differences in indexes
Version 1.1.98
Released May 8th, 2024
Bug Fixes
- Fixed bug where PostgresCompare was failing to fetch the version number of PostgreSQL databases on Linux or MacOS
Version 1.1.97
Released May 6th, 2024
Improvements
- Updated .NET Core to v8
- Refreshed the UI on the schema comparisons list
Version 1.1.94
Released April 1st, 2024
Bug Fixes
- Fixed bug where PostgresCompare would attempt to read a now removed field from pg_database
Version 1.1.93
Released March 22nd, 2024
New Features
- Support variadic function arguments
Version 1.1.91
Released July 30th, 2022
Improvements
- Quote the object name fields when generating a CSV report
Version 1.1.90
Released July 28th, 2022
Improvements
- Add owner to CREATE sql for Materialized View
Version 1.1.89
Released July 7th, 2022
Bug Fixes
- Fix blank window issue on macOS
Version 1.1.88
Released June 22nd, 2022
Bug Fixes
- Fix escaping of CSV report
Version 1.1.87
Released November 15th, 2021
Bug Fixes
- Fixed comparison of Casts
- Added :: cast notation when changing data type of a column
- Fixed filtering of tables to schema for data projects
Version 1.1.86
Released October 5th, 2021
Bug Fixes
- Fixed navigation and display of data projects
Version 1.1.85
Released September 22nd, 2021
New Features
- Added comparison of Configuration Parameters
Version 1.1.84
Released September 13th, 2021
New Features
- Added history view
Version 1.1.83
Released August 5th, 2021
Bug Fixes
- Fix comparison of partitions when comparing single schemas
Version 1.1.82
Released July 31st, 2021
Improvements
- Ignore differing schema names when comparing single schemas
Version 1.1.80
Released June 20th, 2021
New Features
- Compare and deploy table partitions
Bug Fixes
- Fix bug deploying timestamp vs timestamp(0) differences
Version 1.1.79
Released June 13th, 2021
Improvements
- Ensure that adding a column comes before adding a foreign key
Version 1.1.78
Released June 4th, 2021
Bug Fixes
- Resolve issue comparing domains
Version 1.1.76
Released June 2nd, 2021
Bug Fixes
- Resolve 'keynotfound' issue with data comparison
- Resolve 'keynotfound' issue with schema comparison
Version 1.1.75
Released May 31st, 2021
Improvements
- Performance improvements, filtering by schema
Version 1.1.74
Released May 2nd, 2021
New Features
- Index include columns
- Index column operator class names
Bug Fixes
- Fix issue where an index implementing a fk constraint was being excluded
- Fix ordering of deployment script when DROP/CREATE a view
Version 1.1.71
Released April 2nd, 2021
New Features
- Compare range types
- Store and recover window state between launches
- Include extensions when comparing single schemas
Version 1.1.69
Released March 22nd, 2021
New Features
- Add sample project option
- Add ignore default arguments option
Version 1.1.68
Released March 15th, 2021
New Features
- Grant/Revoke privileges in deploy script
- Show script folder progress
- Add a description for a project
Version 1.1.67
Released March 8th, 2021
Improvements
- Sort differences with identical last
- Added edit project button
- Add view dependency planning
Version 1.1.66
Released March 1st, 2021
New Features
- Add remaining object types to scripts folder creation
Bug Fixes
- Fix issue comparing check constraint definitions between postgres versions
Version 1.1.65
Released February 22nd, 2021
New Features
- Added first pass at scripts folder creation
Older Versions
Prior releases
Historical Releases
- v1.1.64 - Fix data compare issue, sort schemas alphabetically
- v1.1.63 - Add scripting of owner of sequences, enums, domains and aggregates
- v1.1.61 - Add comparison of Aggregates, new dependency calculation
- v1.1.60 - Add comparison of privileges for functions, views, sequences, schemas
- v1.1.59 - Fixed test connection feedback
- v1.1.58 - Improved comparison performance, fixed v12 WHEN clause issue
- v1.1.57 - Add comparison of privileges
- v1.1.52 - Fix data compare 'Sequence contains no elements'
- v1.1.51 - Fix deployment of CREATE POLICY, added altered primary key
- v1.1.50 - Fix title bar on MacOS, improve query performance
- v1.1.49 - Fix export report/save script, DROP POLICY, CREATE PUBLICATION
- v1.1.48 - Fix frozen UI issue, add new onboarding
- v1.1.47 - Detect differences in partition by clause, include CLI
- v1.1.46 - Fix Citus tables being ignored, UI refactoring
- v1.1.42 - Fix data compare issues, persist filter on projects list
- v1.1.41 - Add environment variables, comments on Domain, Composite Type, MView
- v1.1.40 - Add CSV report, improved keyboard navigation
- v1.1.39 - Fix comparing views, procedure signature, NOT NULL scripting
- v1.1.38 - Remove Easter Egg, fix OnUpdate, ReturnsSet properties
- v1.1.35 - Improve performance, fix argument defaults, UI responsiveness
- v1.1.34 - Add data compare beta
- v1.1.33 - Fix deploying column comments, refactor options
- v1.1.32 - Deploy precision differences
- v1.1.31 - UI improvements, fix column name escaping, expression index parsing
- v1.1.30 - UI improvements, add 'ignore column order' option
- v1.1.28 - Deploy serial datatype changes, support v9.3
- v1.1.27 - Deploy identity column differences
- v1.1.16 - Add PostgreSQL 12 support
- v1.0.45 - Added licensing
- v1.0.0-alpha - Initial release (March 14th, 2018)