hi. The four patches attached are to solve the TODO1: We need to think for --exclude-database=PATTERN for pg_restore. it is based on your v11_pg_dumpall-with-directory-tar-custom-format-21-jan.patch
0001. pg_dumpall --exclude-database=PATTERN already works,
main function resolve pattern matching is expand_dbname_patterns.
make it an extern function, so pg_restore --exclude-database can also use it.
0002 cosmetic code changes not in pg_restore.c
0003 cosmetic code changes in pg_restore.c
0004 fully implement pg_restore --exclude-database=PATTERN
similar to pg_dumpall.c
declare two file static variables:
static SimpleStringList database_exclude_names = {NULL, NULL};
static SimpleStringList db_exclude_patterns = {NULL, NULL};
I also deleted the function is_full_pattern.
I use
$BIN10/pg_restore --exclude-database=*x* --exclude-database=*s*
--exclude-database=*t* --verbose --file=test.sql x1.dump
the verbose message to verify my changes.
v11-0002-minor-coesmetic-change-not-in-pg_restore.c.no-cfbot
Description: Binary data
v11-0004-preliminary-work-for-pg_restore-exclude-datab.no-cfbot
Description: Binary data
v11-0001-move-expand_dbname_patterns-to-common_dumpall.no-cfbot
Description: Binary data
v11-0003-minor-coesmetic-change-in-pg_restore.c.no-cfbot
Description: Binary data
