Re: Veritas netbackup live backup?

2009/7/17 Guy Watkins <guy.postgresql@gmail.com>:
> Doing some research here and need to know if a PostGreSQL database can be
> backed up without any down time.  We use Veritas netbackup here if that
> helps.  A live export of the database to disk would be fine, but I could not
> find anything like that in the manual.

To expand on what Tom said, I think the options are:

1.)  Use pg_dumpall to create a dump file and then back that up with
NetBackup.; or
2.)  Make sure that the database is shut down when NetBackups backs up
the files; or
3.)  Use the Point in Time Recovery feature to back up the database
while it is running (but you need to run a command before the backup
and another one afterwards.)

--
Michael Wood <esiotrot@gmail.com>