Andres Freund <andres@anarazel.de> writes:
> I wonder if there's a scenario in which a schema restore uses enough
> xids to get close to anti-wraparound territory?
Interesting question ... you'd need one heck of a lot of objects in
the cluster, but we've certainly heard of people with lots of objects.
We could stave that problem off by running the restore steps in
--single-transaction mode, if it weren't that pg_restore will reject the
combination of --create and --single-transaction. I wonder if we should
allow that, specifying that it means that the single transaction starts
after we reconnect to the new DB.
regards, tom lane