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.
