Skip site navigation (1) Skip section navigation (2)

Re: Veritas netbackup live backup?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Michael Wood <esiotrot(at)gmail(dot)com>
Cc: Guy Watkins <guy(dot)postgresql(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Veritas netbackup live backup?
Date: 2009-08-09 18:13:46
Message-ID: 200908091813.n79IDkk29915@momjian.us (view raw or flat)
Thread:
Lists: pgsql-novice
Michael Wood wrote:
> 2009/7/17 Guy Watkins <guy(dot)postgresql(at)gmail(dot)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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-novice by date

Next:From: robin isardDate: 2009-08-09 19:52:29
Subject: psql o and g options not working
Previous:From: Intengu TechnologiesDate: 2009-08-09 10:15:15
Subject: Re: Howto define a constraint in a existing column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group