| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2022-07-26 16:29:45 |
| Message-ID: | fccf0c6a-b7d2-4535-41a1-dc024fb18520@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-07-26 17:48:47 | Re: |
| Previous Message | Adrian Klaver | 2022-07-26 15:22:28 | Re: |