Re: Veritas netbackup live backup? - Mailing list pgsql-novice

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. +