cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Attention DBAs! New with NetBackup 10.4, PostgreSQL Recovery to PIT in Hours/Minutes/Seconds!!

GNeil
Level 4
Employee

2 weeks ago

Hi Friends,

Veritas realizes that as a Database Administrator Point In Time (PIT) recoveries to the second are required when vital data needs to be restored.  Manual recovery can introduce errors and adds times to critical business applications.  New with Veritas NetBackup 10.4, PostgreSQL recovery to PIT in hours/minutes/seconds.

Configuration

Backup

PostgreSQL Recovery to PIT is simple to setup and recover from the NetBackup WebUI.

  1. Create Protection Plans for the PostgreSQL Full and Incremental backups for your database instance(s).  The highlighted Protection Plan does a full backup every 40 minutes and an incremental every 10 minutes.

GNeil_10-1713201013024.png

 

Notice this protection plan does a full backup every 40 minutes and incrementals every 10 minutes.

GNeil_11-1713201013049.png

 

  1. From the Workloads tab, select PostgreSQL and find your database instance to backup.  Notice the Instance is currently Not Protected.  Click the three dots on the right side of the WebUI and select Add Protection.

GNeil_12-1713201013066.png

 

  1. Select the Protection Plan created for your PIT PostgreSQL database instance.

GNeil_13-1713201013076.png

 

  1. Click the Protect button.

GNeil_14-1713201013098.png

 

  1. The PostgreSQL database instance is now protected by the selected Protection Plan.

GNeil_15-1713201013106.png

Recovery

Recovery of the PostgreSQL database instance is even easier and can be accomplished in a few simple steps.

  1. After a successful Full and Incremental backup of the new Protection Plan, a PIT restore can occur at any time between those two backups.

Note:  Check the Activity Monitor for the Full and Incremental backup status.

GNeil_16-1713201013123.png

 

  1. Click on Workloads and PostgreSQL tab in the WebUI.  Click on the three dots of the intance you want to restore.  Find the incremental PIT you want to restore and click the three dots.  Select Perform Point In Time Recovery.

GNeil_17-1713201013141.png

 

  1. Select the time to the second that you want to restore and click Next.

GNeil_18-1713201013144.png

 

  1. Ensure the host is correct and select if you want everything restored to the original or to a different location.

GNeil_19-1713201013153.png

 

  1. NetBackup will restore your PIT backup up to the second.

Veritas NetBackup is not just your trusted on-site backup suite, it’s also your one stop shop to backup to your cloud resources with simple tools that accomplish difficult tasks.  NetBackup enterprise tools makes backing up your data easier and more secure than ever.

0 Kudos
0 REPLIES 0