Answer

PostgreSQL dump based backup is filling C: drive up to 100 percent

+6

Hi All,

During the PostgreSQL backup the C: drive is filling up to 100%. The database itself has about 400 GB on D: drive.

The disk space used on C: is 34 GB when no backups are running. But 150 GB (whole disk) is used during backups.

I need to prevent the C: drive from getting full during the backup.

What fills up the C: drive?

Is it possible to redirect it to another drive/folder?

Any other ideas?

Thank you,

Lubos

Best answer by Lubos Dvorak

Setting sPGCompDump and sPGStagingDir did not solve the issue as the backup became much slower.

Finally we increased the size of the C: drive.

+16

My first guess is the Commvault Job Results folder.

Here is the change location instruction:

+7

Hi Lubos,

Please check if the same pg_dump command consumes so much C:\ space when performed outside of Commvault. You will get the command from PostGresBackup.log
If you see -Fc in the command , it is performing a compressed dump, which is not enabled by default. Default format is tar (-Ft). Compressed dump is enabled with registry key sPGCompDump set on client. Staging is must for this type of dump and default staging path is job results directory. To change staging path, sPGStagingDir can be used.

Regards,

Meera