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?
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?
What problem is it causing?
The normal custom format backup took more than day
On Tue, 26 Jul, 2022, 20:34 Adrian Klaver, <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
