RE: pg_dump is filling C: drive up to 100 percent
Hi Thomas, This worked for me, thanks a lot. Regards, Meera From: Thomas Boussekey Sent: Tuesday, July 19, 2022 5:33 PM To: Meera Nair Cc: Abdul Qoyyuum ; pgsql-general@lists.postgresql.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 mailto:mn...@commvault.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=05%7C01%7Cmnair%40commvault.com%7C25d823f8dd8e45dfcbd808da697ebb45%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938290274062926%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=pbt6xRe2cpru0n%2B7kNFpiGgeAm7BzfYYjIvTWEWUD%2BY%3D=0> Regards, Meera From: Abdul Qoyyuum mailto:aqoyy...@cardaccess.com.au>> Sent: Tuesday, July 19, 2022 3:40 PM To: Meera Nair mailto:mn...@commvault.com>> Cc: pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.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=05%7C01%7Cmnair%40commvault.com%7C25d823f8dd8e45dfcbd808da697ebb45%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938290274062926%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=wMZcngDmewkZK4uQl04IGkf9SBg4YLViVUQAjLtNN94%3D=0> On Tue, Jul 19, 2022 at 4:33 PM Meera Nair mailto:mn...@commvault.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
Re: pg_dump is filling C: drive up to 100 percent
Hello Meera, Le mar. 19 juil. 2022 à 13:42, Meera Nair 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 > *Sent:* Tuesday, July 19, 2022 3:40 PM > *To:* Meera Nair > *Cc:* pgsql-general@lists.postgresql.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=05%7C01%7Cmnair%40commvault.com%7C3ec9f731977545dc7aba08da696ee8e6%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938222475670312%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=jsdU7sEJAlpkshOkOQ3X7KQnnALAD43G8jxDfSkOaOI%3D=0> > > > > On Tue, Jul 19, 2022 at 4:33 PM Meera Nair 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
RE: pg_dump is filling C: drive up to 100 percent
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 Sent: Tuesday, July 19, 2022 3:40 PM To: Meera Nair Cc: pgsql-general@lists.postgresql.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=05%7C01%7Cmnair%40commvault.com%7C3ec9f731977545dc7aba08da696ee8e6%7C40ed1e38a16e46229d7c45161b6969d5%7C0%7C0%7C637938222475670312%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=jsdU7sEJAlpkshOkOQ3X7KQnnALAD43G8jxDfSkOaOI%3D=0> On Tue, Jul 19, 2022 at 4:33 PM Meera Nair mailto:mn...@commvault.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
Re: pg_dump is filling C: drive up to 100 percent
Try dumping without tar format. https://dba.stackexchange.com/a/52730 On Tue, Jul 19, 2022 at 4:33 PM Meera Nair 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
pg_dump is filling C: drive up to 100 percent
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