Skip to main content
commvault.com commvault.com
Solved

PostgreSQL Dumpbased performance

  • October 20, 2021
  • 3 replies
  • 842 views
P
Commvault Certified Expert
Forum|alt.badge.img+8
  • PatrikCommvault Certified Expert
  • Commvault Certified Expert
  • 42 replies

Hi, 

We have PostgreSQL Clients with both FSBased and DumpBased backups running as dba’s want to have both point in time restore and table-based restore possibilities. 

The FSBased backups runs fine with good performance but the DumpBased backups are slow. If I configure more than one stream they are allocated but one stream at the time is used anyway. 

Is there a way to speed up these DumpBased backups? 

Will Block-Level backups provide the same requirements for restores? ie both granular and point in time log restores? 

Regards,

/Patrik  

Best answer by Meera

Hi Patrik, 

Block level feature is the best solution for them. You can find the kernel versions supported here, https://documentation.commvault.com/11.24/expert/21623_postgresql_block_level_backup.html

 

Regards,

Meera

View original
Did this answer your question?

3 replies

M
Vaulter
Forum|alt.badge.img+5

@Patrik,


The process uses only one stream as we could only take the dump of one database at a time.
We need the speed of the database dump. Could you please open a ticket and provide logs of a recent dump based backup for review?

From the block level backups, we can achieve point-in-time restore and granular restore as well. Please check the following links for more details.

https://documentation.commvault.com/11.24/expert/11731_block_level_backups.html

https://documentation.commvault.com/11.24/expert/21630_restore_postgresql_database_tables_and_instances_from_block_level_backup.html

 


Please let me know in case of any questions.

--
Mahender

Mike Struening
1 person likes this
  • Mike Struening
    Mike Struening
Meera
Vaulter
Forum|alt.badge.img+7
  • MeeraVaulter
  • Vaulter
  • 70 replies
  • Answer
  • October 21, 2021

Hi Patrik, 

Block level feature is the best solution for them. You can find the kernel versions supported here, https://documentation.commvault.com/11.24/expert/21623_postgresql_block_level_backup.html

 

Regards,

Meera

Meera
Mike Struening
1 person likes this
  • Mike Struening
    Mike Struening
Martin.Roende
Byte
Forum|alt.badge.img+2

@Meera In this topic the kernel versions supported seems to be of importance.
Our customer is running Oracle Linux version 8.6 and in the support list for Postgresql Block level backup Supported kernels versions, the highest version is above 7.5  = Oracle Linux 7.x with kernel 3.8.13.x .
https://documentation.commvault.com/11.26/expert/21623_postgresql_block_level_backup.html#list-of-supported-kernel-versions

Is there a way to get this to work anyway?
What are the limitations to setup Postgresql Block level backup on Oracle Linux 8.6 ?

Regards Martin

Best regards

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings