Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5821~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5821
Choose a head ref
  • 3 commits
  • 6 files changed
  • 2 contributors

Commits on Jun 16, 2025

  1. pg_restore --clean --data-only 

    Issues a TRUNCATE before COPYing the data into the tables, within a
transaction.

As a result it avoids logging to the WAL, when combined with
wal_level=minimal.
    @jimis
    jimis authored and Commitfest Bot committed Jun 16, 2025
    Configuration menu
    Copy the full SHA
    7809629 View commit details
    Browse the repository at this point in the history

  2. Add new test file with pg_restore test cases 

    Test restoring from custom format dumps, with and without offsets in the
table of contents - the latter happens when pg_dump writes to stdout.

Compare restored database contents to the original database.

Test parallel restore -j2 as well as sequential.

Test --single-transaction.

Test --data-only and --clean --data-only.
    @jimis
    jimis authored and Commitfest Bot committed Jun 16, 2025
    Configuration menu
    Copy the full SHA
    7c7f634 View commit details
    Browse the repository at this point in the history

  3. [CF 5821] v3 - Implement "pg_restore --data-only --clean" as a way to… 

    … skip WAL

This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5821

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/[email protected]
Author(s): Dimitrios Apostolou
    Commitfest Bot committed Jun 16, 2025
    Configuration menu
    Copy the full SHA
    216a79a View commit details
    Browse the repository at this point in the history
Loading