Re: Continuous archiving and wal generation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>> On Fri, Oct 19, 2007 at  1:40 AM, in message
<2ca799770710182340y9877687i8e82cd6847f37c5a@xxxxxxxxxxxxxx>, "Mikko Partio"
<mpartio@xxxxxxxxx> wrote: 
> 
> To make use of the backup, you will need to keep around all the WAL segment
> files generated during and after the file system 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.
> 
> My question is: if I have a large database which takes some time to backup
> with tar, and during the interval between pg_start_backup() and
> pg_stop_backup() more than one wal file gets generated, do I have to store
> in addition to the base backup all wal files generated during the backup
> interval or just the one specified by the .backup file?
> 
> I'm trying to figure out the minimum required to restore from a backup
 
If you look inside that backup file, you'll see something like this:
 
START WAL LOCATION: 47/11B7E980 (file 000000010000004700000011)
STOP WAL LOCATION: 47/13006410 (file 000000010000004700000013)
CHECKPOINT LOCATION: 47/11B7E980
START TIME: 2007-10-12 19:00:02 CDT
LABEL: 2007-10-12_190002
STOP TIME: 2007-10-12 20:10:30 CDT
 
It tells you what files  you need, as a minimum, to restore.
 
-Kevin
 



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux