Re: pg_dump is filling C: drive up to 100 percent

Hello Meera,

Le mar. 19 juil. 2022 à 13:42, Meera Nair <mnair(at)commvault(dot)com> a écrit :

> Hi Abdul,
>
>
>
> We do realize that. With tar format, is there a way to customize the path
> used for temporary local files?
>
> Some way to configure another drive instead of using C:\?
>

I would try this solution: https://superuser.com/a/1448861/278835

>
>
> Regards,
>
> Meera
>
>
>
> *From:* Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au>
> *Sent:* Tuesday, July 19, 2022 3:40 PM
> *To:* Meera Nair <mnair(at)commvault(dot)com>
> *Cc:* pgsql-general(at)lists(dot)postgresql(dot)org
> *Subject:* Re: pg_dump is filling C: drive up to 100 percent
>
>
>
> External email. Inspect before opening.
>
>
>
> Try dumping without tar format. https://dba.stackexchange.com/a/52730
> <https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdba.stackexchange.com%2Fa%2F52730&data=05%7C01%7Cmnair%40commvault.com%7C3ec9f731977545dc7aba08da696ee8e6%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938222475670312%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=jsdU7sEJAlpkshOkOQ3X7KQnnALAD43G8jxDfSkOaOI%3D&reserved=0>
>
>
>
> On Tue, Jul 19, 2022 at 4:33 PM Meera Nair <mnair(at)commvault(dot)com> wrote:
>
> Hi team,
>
>
>
> pg_dump is filling C:\
>
>
>
> This is for postgres version 12. Binary directory, data directory are in
> E:\
>
> I’m redirecting pg_dump output also to E:\, I was taking a tar dump output.
>
> But C:\ is getting filled up . Looks like it is used for some sort of
> temporary staging.
>
> Is there a way not to use C:\ for this?
>
>
>
> Regards,
>
> Meera
>
>
>
>
>
>
> --
>
> Abdul Qoyyuum Bin Haji Abdul Kadir
>
> HP No: +673 720 8043
>

HTH,
Thomas