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

From: Meera Nair <mnair(at)commvault(dot)com>
To: Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: pg_dump is filling C: drive up to 100 percent
Date: 2022-07-19 11:33:44
Message-ID: BY3PR19MB52199C4D756C52A0E5E9504ABA8F9@BY3PR19MB5219.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:\?

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<mailto: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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Boussekey 2022-07-19 12:02:53 Re: pg_dump is filling C: drive up to 100 percent
Previous Message Martin Kalcher 2022-07-19 11:15:42 Re: [PATCH] Introduce array_shuffle() and array_sample()