public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Migration from CentOS7 to RedHat 9
Date: Sat, 10 Aug 2024 09:05:19 -0400
Message-ID: <CANzqJaDeA9f6P8xs0rZwYB6tbSy9hFibcBGwQqaSpenE3pCSBg@mail.gmail.com> (raw)
In-Reply-To: <CAB5fag6e2Safycg22jSPK152WTnW11mWHXqTEox3Fp6Opk80Pw@mail.gmail.com>
References: <CAB5fag6e2Safycg22jSPK152WTnW11mWHXqTEox3Fp6Opk80Pw@mail.gmail.com>
On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <[email protected]> wrote:
> Hi All
>
> I took dump via pg_dump doing ssh from Red hat it took almost 10 hours for
> 400GB data including 99GB of BLOBS large objects.
>
> ssh postgres@ipaddre "pg_dump -U postgres -d DB1 F c -b -v" >
> /path/pg.dump
>
I see a typo. Is this a copy/paste of what you ran?
Is this normal?
>
Maybe. Blobs are slow. I'd have done a multi-threaded pg_dump, though
blobs might be the bottleneck.
--
Death to America, and butter sauce.
Iraq lobster!
view thread (6+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected]
Subject: Re: Migration from CentOS7 to RedHat 9
In-Reply-To: <CANzqJaDeA9f6P8xs0rZwYB6tbSy9hFibcBGwQqaSpenE3pCSBg@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox