MIME-Version: 1.0
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com>
 <A01D7215-2691-4FA6-8B79-E197B7DB9351@gmail.com> <98965993.3138805.1731699978332@mail.yahoo.com>
 <564950518.5117550.1733177884387@mail.yahoo.com> <CANzqJaAda4nZbkG=c+72ry5GdaxrJ6Jzr6fz1quhq8tTfaX1Pg@mail.gmail.com>
 <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com>
 <CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com>
 <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com>
 <CAKAnmmKZdhnhdNRd3OgDyEco9OPkT=qA_TeWMFMRvUM9pXauKg@mail.gmail.com>
 <1482982714.8486017.1735661703839@mail.yahoo.com> <1763130721.4001842.1737733841628@mail.yahoo.com>
 <c3fc88ef-d155-4455-bc01-2c569b401998@aklaver.com> <132487461.4068668.1737741687606@mail.yahoo.com>
 <0dc06cb7-33cc-43ba-a95f-535fdf0a0439@aklaver.com> <1751608443.5432365.1738081421269@mail.yahoo.com>
 <74599d1d-c8a2-4e59-a50d-019dcc973de8@aklaver.com> <200665967.5560583.1738095230696@mail.yahoo.com>
In-Reply-To: <200665967.5560583.1738095230696@mail.yahoo.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 28 Jan 2025 16:27:15 -0500
Message-ID: <CANzqJaAPtHoZHFWawcTJn75dZnfAmQnVJSewP-ai8Z6TNUexJg@mail.gmail.com>
Subject: Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " -
 old vm to new vm
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000e6cc5062ccadcaa"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAPtHoZHFWawcTJn75dZnfAmQnVJSewP-ai8Z6TNUexJg%40mail.gmail.com>
Precedence: bulk

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

On Tue, Jan 28, 2025 at 3:13=E2=80=AFPM Bharani SV-forum <esteembsv-forum@y=
ahoo.com>
wrote:

> TQ Adrian
> another Question on the measuring egress (out bound traffic) /ingress
> (inbound traffic) w.r.to " pg_dumpall " during usage of
>
> pg_dumpall -h  <old vm>  -p 5432 | psql -p 5462
>
> taking data from old_vm and copying to new_vm, as i need to use across th=
e
> network for taking data and i cannot use "pg_upgrade" tool as AWS - AL3
> doesnot support postgresql 13 - community edition.
>
> My existing DB size is  *around 60 GB* (all the DB's) using postgresql
> Ver 13.
>

iotop is *always* useful.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Jan 28, 2025 at 3:13=E2=80=AFPM B=
harani SV-forum &lt;<a href=3D"mailto:esteembsv-forum@yahoo.com">esteembsv-=
forum@yahoo.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_c=
ontainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style=
=3D"font-family:&quot;Helvetica Neue&quot;,Helvetica,Arial,sans-serif;font-=
size:16px"><div></div>
        <div dir=3D"ltr">TQ Adrian</div><div dir=3D"ltr">another Question o=
n the measuring egress (out bound traffic) /ingress (inbound traffic) <a hr=
ef=3D"http://w.r.to" target=3D"_blank">w.r.to</a> &quot; pg_dumpall &quot; =
during usage of=C2=A0</div><div dir=3D"ltr"><br></div><div dir=3D"ltr"><spa=
n><span style=3D"font-size:12pt;line-height:115%;font-family:Aptos,sans-ser=
if">pg_dumpall
-h=C2=A0 &lt;old vm&gt;=C2=A0 -p 5432 | psql -p 5462</span></span><br></div=
><div dir=3D"ltr"><span><span style=3D"font-size:12pt;line-height:115%;font=
-family:Aptos,sans-serif"><br></span></span></div><div dir=3D"ltr"><span><s=
pan style=3D"font-size:12pt;line-height:115%;font-family:Aptos,sans-serif">=
taking data from old_vm and copying to new_vm, as i need to use across the =
network for taking data and i cannot use &quot;pg_upgrade&quot; tool as AWS=
 - AL3 doesnot support postgresql 13 - community edition.</span></span></di=
v><div dir=3D"ltr">=C2=A0</div><div dir=3D"ltr">My existing DB size is=C2=
=A0 <b>around 60 GB</b> (all the DB&#39;s) using postgresql Ver 13.</div></=
div></div></blockquote></div><div><br clear=3D"all"></div><div>iotop is <i>=
always</i> useful.</div><div><br></div><span class=3D"gmail_signature_prefi=
x">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr=
">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39=
;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></d=
iv></div></div>

--0000000000000e6cc5062ccadcaa--