On 7/26/22 10:22, Adrian Klaver wrote:
On 7/26/22 08:15, Rama Krishnan wrote:
Hi Adrian
Thanks for your reply,
My actual db size was 320G while I am taking custom format and moving
into directly S3 it took more than one day so I am trying to use
directory format because parllel option (-j option) supports ik
directory format.
Is the database in AWS also or is it locally hosted?
In either case what is the network distance that the data has to cross?
What is the network speed of the slowest link?
What is size of table?
I m having two Database example
01. Cricket 320G
02.badminton 250G
So you are talking about an entire database not a single table, correct?
In a private email, he said that this is what he's trying:
Pg_dump -h endpoint -U postgres Fd - d cricket | aws cp - s3://dump/cricket.dump
It failed for obvious reasons.
--
Angular momentum makes the world go 'round.
