Re: Help in vetting measuring egress/ingress w.r.to " pg_dumpall " - old vm to new vm

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>
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>
Date: 2025-01-28T21:45:44Z
Lists: pgsql-general
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