From: | Meera Nair <mnair(at)commvault(dot)com> |
---|---|
To: | Thomas Boussekey <thomas(dot)boussekey(at)gmail(dot)com> |
Cc: | Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au>, "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 12:07:17 |
Message-ID: | BY3PR19MB5219A9F9188643442D6C2B0BBA8F9@BY3PR19MB5219.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Thomas,
This worked for me, thanks a lot.
Regards,
Meera
From: Thomas Boussekey <thomas(dot)boussekey(at)gmail(dot)com>
Sent: Tuesday, July 19, 2022 5:33 PM
To: Meera Nair <mnair(at)commvault(dot)com>
Cc: Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au>; 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.
Hello Meera,
Le mar. 19 juil. 2022 à 13:42, Meera Nair <mnair(at)commvault(dot)com<mailto: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<https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsuperuser.com%2Fa%2F1448861%2F278835&data=05%7C01%7Cmnair%40commvault.com%7C25d823f8dd8e45dfcbd808da697ebb45%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938290274062926%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=pbt6xRe2cpru0n%2B7kNFpiGgeAm7BzfYYjIvTWEWUD%2BY%3D&reserved=0>
Regards,
Meera
From: Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au<mailto:aqoyyuum(at)cardaccess(dot)com(dot)au>>
Sent: Tuesday, July 19, 2022 3:40 PM
To: Meera Nair <mnair(at)commvault(dot)com<mailto:mnair(at)commvault(dot)com>>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org<mailto: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%7C25d823f8dd8e45dfcbd808da697ebb45%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938290274062926%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=wMZcngDmewkZK4uQl04IGkf9SBg4YLViVUQAjLtNN94%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
HTH,
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Ray O'Donnell | 2022-07-19 12:10:13 | Re: restore question |
Previous Message | Mladen Gogala | 2022-07-19 12:03:57 | Re: postgis |