Backup with Netbackup 7.1 postgreSQL

As there, to my knowledge, is no NBU agent available for PostgreSQL, you have following options;

* Offline backup: Pre-backup scripts shuts down the DB, back up the file systems, post-backup scripts starts the DB

* Online backup: Cron script/Pre-backup script use pg_dump to dump the DB to local staging area, back up staging area, post-backup script cleans up staging area

* Online, inconsistent backup: Back up the file systems with DB online (inconsistent), back up the archived WAL files (requires the DB to use write-ahead logs). Recover DB by restoring file systems and the replay the WAL.

A few years ago I did a study in how to build a solution similar to the one that exist for MySQL in order to provide online backup directly to a storage unit (no staging area required). The result; It is doable...

/A

Is there any Symantec Documentation for these options that are describing the steps in detail? 

I would personally start with PostgreSQL documentation to see what they recommend for backups.

If you can tell us how PostgreSQL backup is done, we can help with the NBU part.

There is no NBU documentation as far as I know, so you would need to combine the documentation from PostgreSQL and NBU in order to build a solution.

You can refer to http://www.postgresql.org/docs/9.1/static/backup.html for configuring PostgreSQL backup in general.

Pre/post backup scripts are covered in NBU Admin guide II; http://www.symantec.com/docs/DOC3654 on page 96 and onwards. You should use bpstart_notify and bpend_notify on the NBU client.

/A