Solved

Postgres DumpBasedBackupSet Restore takes longer

Hi,

We are trying to do a Postgres DumpBasedBackupSet Restore, but it takes longer for restore to finish.

Like 300Gb take a 1 ½ day and we end up killing the job!!!

Any help/suggestions to improve the speed?

On hardware side we have enough resources:

Source:

Postgres version : 10.17

OS: CentOS stream 8

Destine:

Postgres version : 14.11

OS: CentOS stream 9

During restore I can’t see the throughput or number of stream allocated.

Thanks,

Best answer by Meera

Hi Mike,

Please contact support, they would help to check further. Is it a cloud instance?

If it is SP 32 or greater, using parallel jobs to dump and restore would give better results. Please refer Using Parallel Jobs to Dump the PostgreSQL Database (commvault.com) This needs new backup performed after enabling parallel jobs option.

+7

Hi Mike,

Please contact support, they would help to check further. Is it a cloud instance?

If it is SP 32 or greater, using parallel jobs to dump and restore would give better results. Please refer Using Parallel Jobs to Dump the PostgreSQL Database (commvault.com) This needs new backup performed after enabling parallel jobs option.

Meera