MIME-Version: 1.0
References: 
 <CAB5fag6e2Safycg22jSPK152WTnW11mWHXqTEox3Fp6Opk80Pw@mail.gmail.com>
In-Reply-To: 
 <CAB5fag6e2Safycg22jSPK152WTnW11mWHXqTEox3Fp6Opk80Pw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 10 Aug 2024 09:05:19 -0400
Message-ID: 
 <CANzqJaDeA9f6P8xs0rZwYB6tbSy9hFibcBGwQqaSpenE3pCSBg@mail.gmail.com>
Subject: Re: Migration from CentOS7 to RedHat 9
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001f91ef061f53ea68"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDeA9f6P8xs0rZwYB6tbSy9hFibcBGwQqaSpenE3pCSBg%40mail.gmail.com>
Precedence: bulk

--0000000000001f91ef061f53ea68
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Aug 10, 2024 at 7:14=E2=80=AFAM Wasim Devale <wasimd60@gmail.com> w=
rote:

> Hi All
>
> I took dump via pg_dump doing ssh from Red hat it took almost 10 hours fo=
r
> 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.

--=20
Death to America, and butter sauce.
Iraq lobster!

--0000000000001f91ef061f53ea68
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Aug 10, 2024 at 7:14=E2=80=AFAM W=
asim Devale &lt;<a href=3D"mailto:wasimd60@gmail.com">wasimd60@gmail.com</a=
>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><div dir=3D"auto">Hi All<div dir=3D"auto"><br></div=
><div dir=3D"auto">I took dump via pg_dump doing ssh from Red hat it took a=
lmost 10 hours for 400GB data including 99GB of BLOBS large objects.</div><=
div dir=3D"auto"><br></div><div dir=3D"auto">ssh postgres@ipaddre &quot;pg_=
dump -U postgres -d DB1 F c -b -v&quot; &gt; /path/pg.dump</div></div></blo=
ckquote><div><br></div><div>I see a typo.=C2=A0 Is this a copy/paste of wha=
t you ran?</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex"><div dir=3D"auto"><div dir=3D"auto">Is this normal?<br></div></div></=
blockquote><div><br></div><div>Maybe.=C2=A0 Blobs are slow.=C2=A0 I&#39;d h=
ave done a multi-threaded pg_dump, though blobs might be the bottleneck.</d=
iv><div><br></div></div><span class=3D"gmail_signature_prefix">-- </span><b=
r><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to Amer=
ica, and butter sauce.<div>Iraq lobster!</div></div></div></div>

--0000000000001f91ef061f53ea68--