postgres backup

Hi Ajal, 

In this case, you will need to create a dump based backup. 

• Create a pre-scrip to generate the a database dump. 
• Configure File System backup backup to take the backup of the dump. 
• Setup a post script to delete the old dumps created post backup. 

Hope this helps!

​@sbhatia  when i installed the agent there are 2 default backup set already created one if dumpbased backup set , i blv commvault automatically create dump when we start the backing it up does that work ?

yes you are right! Dump based backupset works here - this backup set will automatically create a dump before backing it up. 

​@sbhatia  ok , so the filesystebackupset only works if archive is enabled , or is there anyway we can take its backup ?

​@Ajal ,

When archive logging is disabled, FileSystem based backup can’t be used. FS based backup is hot backup and archive logs are needed to make the backup consistent.

You can use the Dump based backups. You don’t need to create any pre/post scripts. Please keep in mind, dump based backups are logical backups based on pg_dump utility and may require locks on the database objects during the dump.

Thanks,

Sunil-

​@Sunil  thank you sunil for your advise , if a customer require 1 hour or 2 hour rpo and not ready to enable archive , is it recommended to have incrementail backup or full backup every 1 or 2 hour 

or any workaround