Postgres Pro
Downloads
Home   >   mailing lists

Thread: Veritas netbackup live backup?

Veritas netbackup live backup?

From
Guy Watkins
Date:
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.

Re: Veritas netbackup live backup?

From
Tom Lane
Date:
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

Re: Veritas netbackup live backup?

From
Michael Wood
Date:
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>

Re: Veritas netbackup live backup?

From
Bruce Momjian
Date:
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. +