MIME-Version: 1.0
References: 
 <CAB5fag6e2Safycg22jSPK152WTnW11mWHXqTEox3Fp6Opk80Pw@mail.gmail.com>
In-Reply-To: 
 <CAB5fag6e2Safycg22jSPK152WTnW11mWHXqTEox3Fp6Opk80Pw@mail.gmail.com>
From: Muhammad Waqas <waqas.m@bitnine.net>
Date: Mon, 12 Aug 2024 10:47:08 +0500
Message-ID: 
 <CAHYHq4WiAe9SZauD-42wbF1BgYVwuhcprXMVLg7Ta-=RDhRL6A@mail.gmail.com>
Subject: Re: Migration from CentOS7 to RedHat 9
To: Wasim Devale <wasimd60@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cb805e061f760681"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHYHq4WiAe9SZauD-42wbF1BgYVwuhcprXMVLg7Ta-%3DRDhRL6A%40mail.gmail.com>
Precedence: bulk

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

what is the bandwidth between source and destination?

what is the memory of your source server?

2024=EB=85=84 8=EC=9B=94 10=EC=9D=BC (=ED=86=A0) =EC=98=A4=ED=9B=84 4:14, W=
asim Devale <wasimd60@gmail.com>=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1:

> 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
>
> Is this normal?
>
> Thanks,
> Wasim
>


--=20
*Muhammad Waqas*
*Senior Technical Support Engineer - Tech Support Center (Karachi)*
Mobile: +92-322-2844150
Email:  *waqas.m@bitnine.net <waqas.m@bitnine.net>*
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.

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

<div dir=3D"ltr">what is the bandwidth between source and destination?<div>=
<br></div><div>what is the memory=C2=A0of your source server?</div></div><b=
r><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">2024=EB=
=85=84 8=EC=9B=94 10=EC=9D=BC (=ED=86=A0) =EC=98=A4=ED=9B=84 4:14, Wasim De=
vale &lt;<a href=3D"mailto:wasimd60@gmail.com">wasimd60@gmail.com</a>&gt;=
=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1:<br></div><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 al=
most 10 hours for 400GB data including 99GB of BLOBS large objects.</div><d=
iv dir=3D"auto"><br></div><div dir=3D"auto">ssh postgres@ipaddre &quot;pg_d=
ump -U postgres -d DB1 F c -b -v&quot; &gt; /path/pg.dump</div><div dir=3D"=
auto"><br></div><div dir=3D"auto">Is this normal?</div><div dir=3D"auto"><b=
r></div><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Wasim=C2=A0</div><=
/div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div><img width=3D"96" height=3D"36" src=3D"https://ci3.goog=
leusercontent.com/mail-sig/AIorK4yAA065PNs0wTn63OKufwEq-K0rorlKQ3zGggLzUsOI=
5cf2JvOBaG3rALen-RF0aigXFyuy850"><div dir=3D"ltr"><div dir=3D"ltr"><div><b>=
<font size=3D"4">Muhammad Waqas</font></b></div><div><b>Senior Technical Su=
pport Engineer - Tech Support Center (Karachi)</b></div><div><font style=3D=
"vertical-align:inherit">Mobile: +92-322-2844150</font></div><div><font sty=
le=3D"vertical-align:inherit">Email:=C2=A0=C2=A0<u><a href=3D"mailto:waqas.=
m@bitnine.net" target=3D"_blank">waqas.m@bitnine.net</a></u></font>=C2=A0</=
div><div><font style=3D"vertical-align:inherit">1st floor, suit no F-04, CO=
LABS Karachi, 8-C Khayaban-e-Tanzeem,=C2=A0</font></div><div><font style=3D=
"vertical-align:inherit">DHA Phase 5 Tauheed Commercial Area,</font></div><=
div><font style=3D"vertical-align:inherit">Defense V Defense Housing Author=
ity, Karachi, Karachi City, Sindh,=C2=A0</font></div><div><font style=3D"ve=
rtical-align:inherit">75500 Pakistan.</font></div></div></div></div><div><b=
r style=3D"color:rgb(34,34,34)"></div></div></div>

--000000000000cb805e061f760681--