pg_easy_replicate

What's Changed

• Quote table name in the VACUUM SQL by @faridco in https://github.com/shayonj/pg_easy_replicate/pull/118
• Exclude tables created by extensions by @faridco in https://github.com/shayonj/pg_easy_replicate/pull/120
• Update sequel requirement from >= 5.69, < 5.80 to >= 5.69, < 5.82 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/128
• Bump rubocop from 1.62.1 to 1.64.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/127
• Bump rake from 13.1.0 to 13.2.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/116
• Bump rubocop-performance from 1.20.2 to 1.21.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/115
• Use db user when adding tables to replication by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/130

Props to @annadowling for thorough testing

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.2.5...v0.2.6

What's Changed

• List only permanent tables by @faridco in https://github.com/shayonj/pg_easy_replicate/pull/113
• Update sequel requirement from >= 5.69, < 5.78 to >= 5.69, < 5.80 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/112
• Bump rubocop-rspec from 2.26.1 to 2.29.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/111
• Bump rubocop from 1.60.1 to 1.62.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/109
• Bump pg from 1.5.4 to 1.5.6 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/107
• Bump thor from 1.3.0 to 1.3.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/103

New Contributors

• @faridco made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/113

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.2.4...v0.2.5

What's Changed

• Introduce PG_EASY_REPLICATE_STATEMENT_TIMEOUT env var by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/101
• Bump rspec from 3.12.0 to 3.13.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/98
• Update sequel requirement from >= 5.69, < 5.77 to >= 5.69, < 5.78 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/99

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.2.3...v0.2.4

What's Changed

• Fix tables check in config_check by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/93
• add option to skip vacuum analyzing on switchover by @honzasterba in https://github.com/shayonj/pg_easy_replicate/pull/92
• Disable statement timeout and reset it before/after vacuum+analyze by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/94
• Add spec for skip_vacuum_analyze by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/95

New Contributors

• @honzasterba made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/92

Highlights

• You can now skip vacuum and analyze by passing --skip-vacuum-analyze to switchover. Thanks to @honzasterba
• Vacuum and Analyze won't run into timeouts. Thanks to the report from @TrueCarry

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.2.2...v0.2.3

What's Changed

• Extend config check to assert for REPLICA IDENTITY on tables and drop index bug fix by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/89

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.2.1...v0.2.2

What's Changed

• Bump rubocop-performance from 1.19.1 to 1.20.2 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/86
• Update sequel requirement from >= 5.69, < 5.76 to >= 5.69, < 5.77 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/84
• Bump rubocop from 1.58.0 to 1.60.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/87
• Bump rubocop-rspec from 2.25.0 to 2.26.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/85
• Don't attempt to drop and recreate unique indices by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/88

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.2.0...v0.2.1

What's Changed

• Bump rake from 13.0.6 to 13.1.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/66
• Update thor requirement from ~> 1.2.2 to >= 1.2.2, < 1.4.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/63
• Add mascot by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/80
• Recreate indices post copy to reduce I/O and make COPY faster by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/81

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.12...v0.2.0

What's Changed

• Bump rubocop-rspec from 2.24.1 to 2.25.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/65
• Quote indent DB name by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/76

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.11...v0.1.12

What's Changed

• Drop existing user with privileges when bootstrapping by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/75

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.10...v0.1.11

What's Changed

• Update sequel requirement from >= 5.69, < 5.71 to >= 5.69, < 5.72 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/45
• Bump rubocop from 1.55.0 to 1.55.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/46
• Bump rubocop-performance from 1.18.0 to 1.19.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/48
• Update sequel requirement from >= 5.69, < 5.72 to >= 5.69, < 5.73 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/53
• Bump syntax_tree from 6.1.1 to 6.2.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/59
• Bump rubocop-rspec from 2.23.0 to 2.24.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/58
• Bump pg from 1.5.3 to 1.5.4 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/51
• Bump rubocop from 1.55.1 to 1.56.3 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/56
• Update sequel requirement from >= 5.69, < 5.73 to >= 5.69, < 5.74 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/61
• Bump rubocop-performance from 1.19.0 to 1.19.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/57
• Add a test for upgrading pg 12 to 15 by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/68
• README updates by @andyatkinson in https://github.com/shayonj/pg_easy_replicate/pull/72
• Update sequel requirement from >= 5.69, < 5.74 to >= 5.69, < 5.76 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/71
• Bump rubocop from 1.56.3 to 1.58.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/70
• Reference the passed in URL and use source db url user when dropping schema by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/74

New Contributors

• @andyatkinson made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/72

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.9...v0.1.10

What's Changed

• Exclude views, temporary tables and foreign tables from #list_all_tables by @tfmcloughlin in https://github.com/shayonj/pg_easy_replicate/pull/39
• Add quote_identifier helper for SQL identifiers. by @tfmcloughlin in https://github.com/shayonj/pg_easy_replicate/pull/40
• Escape db user name in queries by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/42
• Require english lib so that $CHILD_STATUS is loaded by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/43
• Bump rubocop from 1.54.2 to 1.55.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/37
• Bump rubocop-rspec from 2.22.0 to 2.23.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/36
• Quote indent username, dbname and schema in all places by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/44

New Contributors

• @tfmcloughlin made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/39

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.8...v0.1.9

What's Changed

• Update sequel requirement from ~> 5.69.0 to >= 5.69, < 5.71 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/31
• Bump rubocop from 1.52.1 to 1.54.0 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/32
• Bump rubocop from 1.54.0 to 1.54.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/33
• Bump rubocop from 1.54.1 to 1.54.2 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/34
• Introduce --copy-schema via pg_dump by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/35

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.7...v0.1.8

What's Changed

• Perform smoke test with retries by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/26
• Default schema to public by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/29
• Perform vacuum and analyze before and after switchover by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/30

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.6...v0.1.7

What's Changed

• Bug fix: Support custom schema name https://github.com/shayonj/pg_easy_replicate/pull/25
• New smoke spec in CI https://github.com/shayonj/pg_easy_replicate/pull/25

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.5...v0.1.6

• Fix bug in stop_sync (https://github.com/shayonj/pg_easy_replicate/commit/44667e0697213932d3505201cf2d61b35e5942e0)

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.4...v0.1.5

What's Changed

• Drop lockbox dependency by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/19
• Support password with special chars and test for url encoded URI by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/22
• Support AWS and GCP special user scenarios and introduce --special-user-role by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/23

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.3...v0.1.4

What's Changed

• Docker multi-platform image build and push from CI by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/18
  • Docker image support for linux/amd64 and linux/arm64 starting 0.1.3

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.2...v0.1.3

What's Changed

• Keep the internal username unique by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/17

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.1...v0.1.2

What's Changed

• Typo fix: lot --> low by @natacado in https://github.com/shayonj/pg_easy_replicate/pull/6
• Correct a typo in cli.rb by @felixonmars in https://github.com/shayonj/pg_easy_replicate/pull/9
• Bump rubocop from 1.51.0 to 1.52.1 by @dependabot in https://github.com/shayonj/pg_easy_replicate/pull/10
• Use PG matrix in CI by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/11
• Fix console leaking into PATH by @shayonj in https://github.com/shayonj/pg_easy_replicate/pull/13

New Contributors

• @natacado made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/6
• @felixonmars made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/9
• @dependabot made their first contribution in https://github.com/shayonj/pg_easy_replicate/pull/10

Full Changelog: https://github.com/shayonj/pg_easy_replicate/compare/v0.1.0...v0.1.1

Hello World 👋🏾

Full Changelog: https://github.com/shayonj/pg_easy_replicate/commits/v0.1.0