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.
Best answer by 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
+13Hi,
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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
