Skip to content

v0.9
Compare
Choose a tag to compare
@dimitri dimitri released this 30 Sep 10:37
· 427 commits to main since this release
v0.9
88c921c
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.

pgcopydb v0.9 (September 30, 2022)

Improve pgcopydb with same-table concurrency support, lots of bug fixes
including the new support for Extension Configuration Tables and the
automated sequences reset after a --follow cutover. New options to control
verbosity have also been added: --debug and --trace are added to --verbose.

The pgcopydb internal sub-process model has been entirely reviewed. In
version 0.9 a System V queue mechanism is used to communicate jobs from a
main process to a list of worker processes. This has been applied to CREATE
INDEX and VACUUM jobs, in a way that with --index-jobs 4 pgcopydb now starts
4 create index worker processes at start-up; where it would before create
worker processes each time a table copy would be finished.

As a result the --index-jobs limit is now enforced correctly.

Added

  • Implement same-table concurrency. (#85)
  • Add support for Extension Configuration Tables (#101)
  • Reset sequences at the end of pgcopydb clone --follow. (#76)
  • Add a summary line for the time taken to query catalogs. (#111)
  • Implement --debug and --trace, adding to --verbose. (#97)
  • Implement pgcopydb list progress [ --json ] (#95)
  • Store the schema elements to a schema.json file. (#94)

Changed

  • Set idle_in_transaction_session_timeout to zero. (#116)
  • Make sure to transform JSON files in all cases. (#115)
  • Improve pgcopydb follow docs, and some more. (#108)
  • Improve docs: intro, design, concurrency. (#102)
  • A round of documentation updates. (#98)
  • Improve documentation of the --follow option. (#81)

Fixed

  • Bug fixes for the transform process. (#114)
  • Use docker-compose run in tests, instead of docker-compose up. (#113)
  • From the lab: we could have more lines in a WAL.json file. (#112)
  • Fix docs for pgcopydb dump schema --target etc. (#109)
  • Add more pg restore object descriptions, from shared logs. (#107)
  • Fix/index jobs (#106)
  • Improve clone --follow sub-process error handling. (#100)
  • Fix reltuples processing: it might be NULL. (#99)
  • Add some other missing pg_restore list descriptions. (#96)
  • Fix version number when building Docker images. (#93)
  • Improve docs and help strings. (#87)
  • Fix environment variable names for table and index jobs. (#86)
  • When pgcopydb clone --follow is used, setup before forking subprocesses. (#83)
  • Fix unit testing to follow latest changes in the pagila database. (#82)
Assets 2
Loading