On 10/18/23 18:42, Scott Ribe wrote:
On Oct 18, 2023, at 5:21 PM, Ron <ronljohnsonjr@gmail.com> 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.