- Added Docker image for
linux/arm64
- Fixed warning with Ruby 3.3
- Dropped support for Ruby < 2.7
- Fixed issue with slop 4.10.0
- Fixed issue with pg 1.4.4
- Fixed output when
pg_restore
not found
- Improved error message when a primary key is required
- Switched to monotonic time
- Fixed schema sync with Homebrew Postgres 14.5
- Fixed random letter data rule generating non-letter
- 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
- Fixed error when schema missing in destination with
--schema-first
and--schema-only
- Fixed connection security for
--schema-first
and--schema-only
- more info
- Added support for tables with generated columns
- Improved help
- Log SQL with
--debug
option - Improved sequence queries
- Added
--defer-constraints-v2
option - Ensure consistent source snapshot with
--disable-integrity
- Added support for
--disable-integrity
on Amazon RDS - Fixed error when excluded table not found in source
- Added Django and Laravel integrations
- 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
- Added
--jobs
option - Added
--defer-constraints
option - Added
--disable-user-triggers
option - Added
--disable-integrity
option - Improved error message for older libpq
- Fixed output for
--in-batches
- Improved Postgres error messages
- Fixed behavior of wildcard without schema
- Added
--fail-fast
option - Automatically exclude tables when
--init
run inside Rails app - Improved error message
- Fixed typo in error message
- Fixed Slop warning with Ruby 2.7
- Improved output when syncing
- Improved output on interrupt
- Added
--no-sequences
option
- Added
sslmode
to template
- Improved flexibility of commands
- Sync all objects when no tables specified
- Made
psql
version check more robust - Fixed issue with non-lowercase primary key
- Prefer
--init
over--setup
- Improved data rules
- Sync all schemas in search path by default
- Added support for socket connections
- Added support for environment variables
- Better support for schemas
- Added
--schemas
option - Added
--all-schemas
option - Added
--schema-first
option - Fixed issue with non-lowercase tables and partial syncs
- Added Windows support
- Added
random_string
andrandom_number
replacement options - Improved performance of
--in-batches
for large tables
- Fixed non-lowercase tables and columns
- Fixed
--truncate
option with--in-batches
- Fixed
Table does not exist in source
error
- Support schemas other than public
- Added
--in-batches
mode for production transfers with--batch-size
and--sleep
- Added
-d
option as an alias for--db
- Added support for wildcard tables
- Fixed
--schema-only
errors
- Prefer
{1}
for interpolation - Added
--overwrite
option - Deprecated
--where
and--limit
- Added
-t
or--tables
,-g
or--groups
options - Deprecated
tables
,groups
, andsetup
commands
- More powerful groups
- Overwrite rows by default when
WHERE
clause (previously truncated) - Added
pgsync users "WHERE id = 1
- Added
pgsync group1
, shorthand forpgsync groups group1
- Added
--schema-only
option - Added
--no-rules
option - Added
--setup
option - Added
--truncate
option
- Added
--preserve
option - Added
--list
option for groups and tables - Added
--limit
option
- Fixed
no PostgreSQL user name specified in startup packet
- Added
--debug
option
- Do not require config file
- Fixed idle transaction timeout errors - respects
statement_timeout
as a result - Raise error when command exits with non-zero status
- Better support for multiple databases
- Search parent directories for config file
- First release