initdb: Add --no-sync-data-files.
Nathan Bossart <nathan@postgresql.org>
initdb: Add --no-sync-data-files. This new option instructs initdb to skip synchronizing any files in database directories, the database directories themselves, and the tablespace directories, i.e., everything in the base/ subdirectory and any other tablespace directories. Other files, such as those in pg_wal/ and pg_xact/, will still be synchronized unless --no-sync is also specified. --no-sync-data-files is primarily intended for internal use by tools that separately ensure the skipped files are synchronized to disk. A follow-up commit will use this to help optimize pg_upgrade's file transfer step. The --sync-method=fsync implementation of this option makes use of a new exclude_dir parameter for walkdir(). When not NULL, exclude_dir specifies a directory to skip processing. The --sync-method=syncfs implementation of this option just skips synchronizing the non-default tablespace directories. This means that initdb will still synchronize some or all of the database files, but there's not much we can do about that. Discussion: https://postgr.es/m/Zyvop-LxLXBLrZil%40nathan
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/initdb.sgml | modified | +27 −0 |
| src/bin/initdb/initdb.c | modified | +8 −2 |
| src/bin/initdb/t/001_initdb.pl | modified | +1 −0 |
| src/bin/pg_basebackup/pg_basebackup.c | modified | +1 −1 |
| src/bin/pg_checksums/pg_checksums.c | modified | +1 −1 |
| src/bin/pg_combinebackup/pg_combinebackup.c | modified | +1 −1 |
| src/bin/pg_rewind/file_ops.c | modified | +1 −1 |
| src/common/file_utils.c | modified | +55 −30 |
| src/include/common/file_utils.h | modified | +1 −1 |
Documentation touched
Discussion
- optimize file transfer in pg_upgrade 45 messages · 2024-11-06 → 2025-12-28