Skip to main content

Hi Community,

 

Is it safe to use software compression with DumpBased PostgresSQL backup ? We’ve had a client complaining about jobs related to PostgresSQL backups taking too long, after a first check, we’ve found that all created subclients under DumpBased had compression turned off, we know that DBs have their own compression, but wanted to be sure of the safeness of using it on commvault side.

 

Regards.

Hi,

Yes you can use software compression for Postgres dump backups.

From the DB dump perspective also we run the pg_dump with -Fc option which compresses the dump by default from Postgres end. We can also enable software compression.

 

However, you can have then run the pg_dump command outside Commvault, which will help identifying whether the performance bottleneck is on Postgres side or CV side.

 

Thanks,

Sunil

 

Hi,

Yes you can use software compression for Postgres dump backups.

From the DB dump perspective also we run the pg_dump with -Fc option which compresses the dump by default from Postgres end. We can also enable software compression.

 

However, you can have then run the pg_dump command outside Commvault, which will help identifying whether the performance bottleneck is on Postgres side or CV side.

 

Thanks,

Sunil

 

Thanks, @Sunil For the clarifications.

Terms & ConditionsCookie settings