CHANGELOG.md

September 12, 2025 ยท View on GitHub

0.8.1 (2025-09-12)

  • Fixed local destination detection when no host present with pg 1.6+

0.8.0 (2024-07-10)

  • Added Docker image for linux/arm64
  • Fixed warning with Ruby 3.3
  • Dropped support for Ruby < 2.7

0.7.4 (2023-03-06)

  • Fixed issue with slop 4.10.0

0.7.3 (2022-11-09)

  • Fixed issue with pg 1.4.4
  • Fixed output when pg_restore not found

0.7.2 (2022-09-19)

  • Improved error message when a primary key is required
  • Switched to monotonic time
  • Fixed schema sync with Homebrew Postgres 14.5

0.7.1 (2022-07-06)

  • Fixed random letter data rule generating non-letter

0.7.0 (2022-03-10)

  • Changed --defer-constraints to --defer-constraints-v1
  • Changed --defer-constraints-v2 to --defer-constraints
  • Fixed unknown alias error with Ruby 3.1
  • Dropped support for Ruby < 2.5

0.6.8 (2021-09-21)

  • Fixed error when schema missing in destination with --schema-first and --schema-only

0.6.7 (2021-04-26)

  • Fixed connection security for --schema-first and --schema-only - more info

0.6.6 (2020-10-29)

  • Added support for tables with generated columns

0.6.5 (2020-07-10)

  • Improved help

0.6.4 (2020-06-10)

  • Log SQL with --debug option
  • Improved sequence queries

0.6.3 (2020-06-09)

  • Added --defer-constraints-v2 option
  • Ensure consistent source snapshot with --disable-integrity

0.6.2 (2020-06-09)

  • Added support for --disable-integrity on Amazon RDS
  • Fixed error when excluded table not found in source

0.6.1 (2020-06-07)

  • Added Django and Laravel integrations

0.6.0 (2020-06-07)

  • Added messages for different column types and non-deferrable constraints
  • Added support for wildcards to --exclude
  • Improved --overwrite and --preserve options for foreign keys
  • Improved output for schema sync
  • Fixed --overwrite and --preserve options for multicolumn primary keys
  • Fixed output for notices

Breaking

  • Syncs shared tables instead of raising an error when tables missing in destination
  • Raise an error when --config or --db option provided and config not found
  • Removed deprecated options
  • Dropped support for Postgres < 9.5

0.5.5 (2020-05-13)

  • Added --jobs option
  • Added --defer-constraints option
  • Added --disable-user-triggers option
  • Added --disable-integrity option
  • Improved error message for older libpq

0.5.4 (2020-05-09)

  • Fixed output for --in-batches

0.5.3 (2020-04-03)

  • Improved Postgres error messages
  • Fixed behavior of wildcard without schema

0.5.2 (2020-03-27)

  • Added --fail-fast option
  • Automatically exclude tables when --init run inside Rails app
  • Improved error message
  • Fixed typo in error message

0.5.1 (2020-03-26)

  • Fixed Slop warning with Ruby 2.7

0.5.0 (2020-03-26)

  • Improved output when syncing
  • Improved output on interrupt
  • Added --no-sequences option

0.4.3 (2019-10-27)

  • Added sslmode to template

0.4.2 (2019-10-27)

  • Improved flexibility of commands
  • Sync all objects when no tables specified

0.4.1 (2018-12-15)

  • Made psql version check more robust
  • Fixed issue with non-lowercase primary key
  • Prefer --init over --setup
  • Improved data rules

0.4.0 (2018-02-28)

  • Sync all schemas in search path by default
  • Added support for socket connections
  • Added support for environment variables

0.3.9 (2018-02-27)

  • Better support for schemas
  • Added --schemas option
  • Added --all-schemas option
  • Added --schema-first option
  • Fixed issue with non-lowercase tables and partial syncs

0.3.8 (2017-10-01)

  • Added Windows support
  • Added random_string and random_number replacement options
  • Improved performance of --in-batches for large tables

0.3.7 (2017-08-30)

  • Fixed non-lowercase tables and columns
  • Fixed --truncate option with --in-batches

0.3.6 (2016-10-02)

  • Fixed Table does not exist in source error

0.3.5 (2016-07-23)

  • Support schemas other than public

0.3.4 (2016-04-29)

  • Added --in-batches mode for production transfers with --batch-size and --sleep

0.3.3 (2016-04-25)

  • Added -d option as an alias for --db
  • Added support for wildcard tables
  • Fixed --schema-only errors

0.3.2 (2016-04-19)

  • Prefer {1} for interpolation
  • Added --overwrite option
  • Deprecated --where and --limit

0.3.1 (2016-04-06)

  • Added -t or --tables, -g or --groups options
  • Deprecated tables, groups, and setup commands

0.3.0 (2016-04-06)

  • More powerful groups
  • Overwrite rows by default when WHERE clause (previously truncated)
  • Added pgsync users "WHERE id = 1
  • Added pgsync group1, shorthand for pgsync groups group1
  • Added --schema-only option
  • Added --no-rules option
  • Added --setup option
  • Added --truncate option

0.2.4 (2016-04-04)

  • Added --preserve option
  • Added --list option for groups and tables
  • Added --limit option

0.2.3 (2016-03-30)

  • Fixed no PostgreSQL user name specified in startup packet

0.2.2 (2016-03-28)

  • Added --debug option

0.2.1 (2016-03-27)

  • Do not require config file

0.2.0 (2016-03-26)

  • Fixed idle transaction timeout errors - respects statement_timeout as a result
  • Raise error when command exits with non-zero status

0.1.1 (2016-03-23)

  • Better support for multiple databases
  • Search parent directories for config file

0.1.0 (2015-12-07)

  • First release