Обсуждение: Veritas netbackup live backup?
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.
Thanks.
Guy Watkins <guy.postgresql@gmail.com> writes: > Doing some research here and need to know if a PostGreSQL database can be > backed up without any down time. Certainly. http://www.postgresql.org/docs/8.4/static/backup.html regards, tom lane
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>
Michael Wood wrote: > 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.) 4. Use file system snapshots That is documented in our manuals too. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +