On Tue, Dec 9, 2025 at 12:18 AM Mahendra Singh Thalor <[email protected]> wrote:
> On Mon, 8 Dec 2025 at 22:39, tushar <[email protected]> wrote: > > Here, I am attaching an updated patch for the review and testing. This > can be applied on commit d0d0ba6cf66c4043501f6f7. > > Thanks, Mahendra, please refer to this scenario where if "--transaction-size" switch is used with pg_dumpall/pg_restore, then the table creation fails (or the table is not created) Steps to reproduce: 1. Connect to the psql terminal, create a table/insert rows { create table t(n int); insert into t values (generate_series(1,15)); } 2. Perform pg_dump operation { ./pg_dumpall -Ft -f tar.dump } 3. new cluster: try to restore with --transaction-size switch { ./pg_restore -Ft tar.dump -C -d postgres --transaction-size=10 } = Table failed to create I have checked via pg_dump/pg_restore using --transaction-size, and it is working fine, i.e, table is created successfully ./pg_dump -Ft -f tar.d postgres ./pg_restore --transaction-size=10 -Ft -d new_database tar.d regards,
