Release Notes

Track the evolution of PostgresCompare with detailed release notes and version history.

Version 1.1.100

Released July 1st, 2024

Latest

⚡ Improvements

  • Removed heading from difference viewer for cleaner UI
Download Version 1.1.100

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)