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