Feedback-ID: i76984098:Fastmail
Message-ID: <21b5d62a-19d1-413f-9d5e-d681cd2bb91b@aklaver.com>
Date: Tue, 28 Jan 2025 13:45:44 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " -
 old vm to new vm
To: Bharani SV-forum <esteembsv-forum@yahoo.com>,
 Greg Sabino Mullane <htamfids@gmail.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.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>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <200665967.5560583.1738095230696@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/21b5d62a-19d1-413f-9d5e-d681cd2bb91b%40aklaver.com>
Precedence: bulk

On 1/28/25 12:13, Bharani SV-forum wrote:
> TQ Adrian
> another Question on the measuring egress (out bound traffic) /ingress 
> (inbound traffic) w.r.to " pg_dumpall " during usage of

Since you are using AWS EC2(?) instances wouldn't the AWS dashboard show 
you this?

> 
> 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 
> the network for taking data and i cannot use "pg_upgrade" tool as AWS - 
> AL3 doesnot support postgresql 13 - community edition.

The PGDG repo does:

https://www.postgresql.org/download/linux/redhat/

Have you tried using it?

Also from what I gather there is no Amazon Linux 3.

There is Amazon Linux 2023, is that what you are referring to?


> My existing DB size is *around 60 GB* (all the DB's) using postgresql 
> Ver 13.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com