On Wed, Feb 12, 2025 at 1:17 AM Mahendra Singh Thalor <mahi6...@gmail.com> wrote: > > > > > There are some tests per https://commitfest.postgresql.org/52/5495, I > > will check it later.
hi. the cfbot failure is related to function _tocEntryRequired if (strcmp(te->desc, "DATABASE") == 0 || strcmp(te->desc, "DATABASE PROPERTIES") == 0) { - if (ropt->createDB) + if (ropt->createDB || AH->format != archNull) return REQ_SCHEMA; else return 0; for restoring multiple databases: in v16 implementation: pg_restore even if you do not specify --create, it actually did what pg_restore --create option does. if there are multiple databases in the archive: to make the pg_restore --file output is usable, the output file need have \connect and CREATE DATABASE command. that is exactly what --create option would do. pg_restore --file behavior need align with pg_restore --dbname. therefore pg_restore restoring multiple databases will use --create option. we can either error out (pg_fatal) saying restoring multiple databases requires the pg_restore --create option. Or we can add a pg_log_info saying pg_restore --create option will be set to true while restoring multiple databases. for restoring one database, the master behavior is fine. so we don't need to change _tocEntryRequired.
v16_misc.nocfbot
Description: Binary data