From: Ron <ronljohnsonjr@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump -Z6 (the default) can be pretty slow
Date: Wed, 18 Oct 2023 19:00:31 -0500
Message-ID: <45e16ff2-da2d-46c3-be52-03cad8eb60a3@gmail.com> (raw)
In-Reply-To: <A271FB1A-55C7-4DB4-813A-EC54454EB573@elevated-dev.com>
References: <c2157b92-8802-41c9-a6b8-435d6d3793c0@gmail.com>
<E9615CEC-CB92-4825-8BFC-0099F90107BD@elevated-dev.com>
<f290f176-4f75-473d-820a-a6257fa9f86f@gmail.com>
<A271FB1A-55C7-4DB4-813A-EC54454EB573@elevated-dev.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump -Z6 (the default) can be pretty slow
In-Reply-To: <45e16ff2-da2d-46c3-be52-03cad8eb60a3@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox