RE: pg_dump is filling C: drive up to 100 percent - Mailing list pgsql-general

From Meera Nair
Subject RE: pg_dump is filling C: drive up to 100 percent
Date
Msg-id BY3PR19MB5219A9F9188643442D6C2B0BBA8F9@BY3PR19MB5219.namprd19.prod.outlook.com
Whole thread Raw
In response to Re: pg_dump is filling C: drive up to 100 percent  (Thomas Boussekey <thomas.boussekey@gmail.com>)
Responses Unable to archive logs in standby server  (Meera Nair <mnair@commvault.com>)
List pgsql-general

Hi Thomas,

 

This worked for me, thanks a lot.

 

Regards,

Meera

 

From: Thomas Boussekey <thomas.boussekey@gmail.com>
Sent: Tuesday, July 19, 2022 5:33 PM
To: Meera Nair <mnair@commvault.com>
Cc: Abdul Qoyyuum <aqoyyuum@cardaccess.com.au>; 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 <mnair@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

 

Regards,

Meera

 

From: Abdul Qoyyuum <aqoyyuum@cardaccess.com.au>
Sent: Tuesday, July 19, 2022 3:40 PM
To: Meera Nair <mnair@commvault.com>
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

 

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

pgsql-general by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: postgis
Next
From: Ray O'Donnell
Date:
Subject: Re: restore question