On Sat, 2005-04-16 at 23:06 -0400, Bruce Momjian wrote: [about backup procedure with PITR documentation
> I see in the docs: > > To make use of this backup, you will need to keep around all the WAL > segment files generated at or after the starting time of the backup. To > aid you in doing this, the pg_stop_backup function creates a backup > history file that is immediately stored into the WAL archive area. This > file is named after the first WAL segment file that you need to have to > make use of the backup. For example, if the starting WAL file is > 0000000100001234000055CD the backup history file will be named something > like 0000000100001234000055CD.007C9330.backup. (The second part of this > file name stands for an exact position within the WAL file, and can > ordinarily be ignored.) Once you have safely archived the backup dump > file, you can delete all archived WAL segments with names numerically > preceding this one. > > I am not clear on what the "backup dump file" is? I assume it means > 0000000100001234000055CD. It is called "WAL segment file" above. I > will rename that phrase to match the above terminology. Patch attached > and applied. Doesn't it refer to the backup file itself (the tar file of the data directory) ? You do not want to start deleting WAL segments until that one is safely archived. gnari ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])