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)