On Wed, Mar 24, 2021 at 1:24 PM Justin Pryzby <pry...@telsasoft.com> wrote: > I think it's not specific to pg_upgrade, but any pg_dump |pg_restore. > > The analogy with tablespaces is restoring from a cluster where the tablespace > is named "vast" to one where it's named "huge". I do this by running > PGOPTIONS=-cdefault_tablespace=huge pg_restore --no-tablespaces > > So I thinks as long as --no-toast-compression does the corresponding thing, > the > "restore with alternate compression" case is handled fine.
I think you might be missing the point. If you're using pg_dump and pg_restore, you can pass --no-toast-compression if you want. But if you're using pg_upgrade, and it's internally calling pg_dump --binary-upgrade, then you don't have control over what options get passed. So --no-toast-compression is just fine for people who are dumping and restoring, but it's no help at all if you want to switch TOAST compression methods while doing a pg_upgrade. However, what does help with that is sticking with what Tom committed before rather than changing to what he's proposing now. If you like his current proposal, that's fine with me, as long as we're on the same page about what happens if we adopt it. -- Robert Haas EDB: http://www.enterprisedb.com
