Re:

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.

What is size of table?

I m having two Database example

01. Cricket 320G
02.badminton 250G

What sort of time interval are you seeing?

I am doing purge data to keep 1 year data n db more than year data I am
going yo take dump backup for future reports purpose.

What problem is it causing?

The normal custom format backup took more than day

On Tue, 26 Jul, 2022, 20:34 Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 7/26/22 06:27, Rama Krishnan wrote:
> > Hi all,
> >
> > How to take a table backup using directory format?
>
> pg_dump -d <some_db> -U <some_user> -t <the_table> -Fd -f <new_dir>
>
> > I am having huge size of table when I am using a pg_dump it tooks more
> > time kindly suggest me
>
> Not sure what the above means, so:
>
> What is size of table?
>
> What sort of time interval are you seeing?
>
> What problem is it causing?
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>