On Oct 18, 2023, at 5:21 PM, Ron <ronljohnsonjr@xxxxxxxxx> wrote: It didn't occur to me to mention that I used it. Do people really still not use -Fd?I don't know--I guess it depends on context. Certainly for upgrades I don't know any reason not to.
Even for nightly backups (we still use pg_dump instead of pgbackrest on a few smaller systems), I always use directory format backups.
I'm still using 9.6, so that feature isn't available yet. When I get the Pg 15 VMs stood up (Pg15 binaries are not available for RHEL 6), I'm definitely going to try that.I thought of that mere seconds after posting my prior reply ;-) Have you considered pg_upgrade?
Since "the migrated databases will be on new servers, and we purge off old partitions and add new partitions, pg_upgrade and logical replication are off the table".
And, of course, 9.6 binaries aren't available at all (at least I can't find 9.6.24 RPMs anywhere under https://download.postgresql.org/pub/), so rsyncing the database files to the new server and then doing a pg_upgrade won't work. Even then, I'd have to rebuild many indices anyway, due to glibc locale changes.
--
Born in Arizona, moved to Babylonia.
Born in Arizona, moved to Babylonia.
