While doing some code changes with pg_dumpall and pg_rsetore[1], we noticed that on_exit_nicely_list array has only fixed slots (MAX_ON_EXIT_NICELY=20) but in some cases, we need more slots for pg_restore. Ex: restore more than 20 databases by single pg_restore command.
We are working on a patch[1] which dumps all the databases in non-text mode by pg_dumpall and then we are restoring those dumps by pg_restore. So we need more slots due to multiple databases.
Apart from the attached patch solution, we thought of some more solutions. Solution 1: reset array index with each database restore, but this might break some other things. Solution 2: for each database, we can keep the index of the on_exit_nicely_list array and after restoring a particular database we can reset the index to old value but this looks like a hack.
Here, I am proposing a patch which will dynamically enlarge the on_exit_nicely_list array by doubling the previous size.
