+13Hi,
A customer has a CPU constraint server with PostgreSQL DB running. DB is approx. 96GB in size. Dumpbased backup took 5h30m which is a very long time to backup 96GB of data. Commvault by default is using pg_dump with -Fc parameter which compresses backup by default
I’m not a DB admin but as far as I know postgreSQL compression is very resource intensive. Is there a way to run PostgreSQL dumpbased backup without pg_dump compression?
Best answer by Meera
Hi Robert,
Is performing file based backups using FSBased BackupSet feasible?
Archive log directory would need to be configured for this.
https://www.postgresql.org/docs/current/continuous-archiving.html
Regards,
Meera
+7Hi Robert,
Is performing file based backups using FSBased BackupSet feasible?
Archive log directory would need to be configured for this.
https://www.postgresql.org/docs/current/continuous-archiving.html
Regards,
Meera
+13Hi
Thanks for you suggestion. The WAL are not currently configured, I spoke with administrator responsible for this particular server but he is concerned about turning on logs further reducing already poor performance of this server. He also told me that this server is gonna be decommissioned soon, so we will just have to struggle on for a couple of days.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
