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 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.klaver@aklaver.com