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

Re: Incremental Backup

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Majid Azimi <majid(dot)merkava(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Incremental Backup
Date: 2010-10-05 12:30:38
Message-ID: 4CAB1A6E.4020406@vmsinfo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Majid Azimi wrote:
> What do you mean by "on-line (hot) backup weekly and a  daily archive 
> backup."
>
> hot backup means using pg_dump?
> what is archive backup? you mean WAL?
The phrase "hot backup" means that the DB is open while backup is taken. 
When you shut the cluster down, the backup is "cold".
I do it  by using pg_start_backup to put the database in the "backup 
mode" (cause it to start logging the entire blocks in the WAL archives, 
not just the changes) and then back i t up with Symantec NetBackup. 
Strictly speaking, pg_dump is not backup since it cannot be used for 
recovery. The function "pg_start_backup is described here:

http://developer.postgresql.org/pgdocs/postgres/functions-admin.html

And yes, by the "archive backup" I mean WAL archives.

-- 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com 


In response to

pgsql-novice by date

Next:From: Mladen GogalaDate: 2010-10-05 17:15:27
Subject: WHEN NO_DATA_FOUND THEN....
Previous:From: Lukasz BrodziakDate: 2010-10-05 06:04:22
Subject: Re: Date help

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