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

[Meera Nair <mnair@xxxxxxxxxxxxx>]

Hi Thomas,

 

This worked for me, thanks a lot.

 

Regards,

Meera

 

From: Thomas Boussekey <thomas.boussekey@xxxxxxxxx>
Sent: Tuesday, July 19, 2022 5:33 PM
To: Meera Nair <mnair@xxxxxxxxxxxxx>
Cc: Abdul Qoyyuum <aqoyyuum@xxxxxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx>
Sent: Tuesday, July 19, 2022 3:40 PM
To: Meera Nair <mnair@xxxxxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
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

 

On Tue, Jul 19, 2022 at 4:33 PM Meera Nair <mnair@xxxxxxxxxxxxx> 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