Majid Azimi wrote:
> What do you mean by "on-line (hot) backup weekly and a daily archive
> 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:
And yes, by the "archive backup" I mean WAL archives.
Sr. Oracle DBA
New York, NY 10036
In response to
pgsql-novice by date
|Next:||From: Mladen Gogala||Date: 2010-10-05 17:15:27|
|Subject: WHEN NO_DATA_FOUND THEN....|
|Previous:||From: Lukasz Brodziak||Date: 2010-10-05 06:04:22|
|Subject: Re: Date help|