Re: WAL files backup

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

 



pedro noticioso wrote:

> regresamos wal files a pg_xlog - COPY BACKED UP WAL
> FILES BACK TO pg_xlog DIRECTORY

This step is wrong.  You don't have to manually put the pg_xlog files in
the pg_xlog directory -- you have to let the recovery_command copy them
back from the archive area.  Note that recovery.conf does not go into
the share/ directory, but in data/.  And it must be present _only_ when
you want the system to attempt the recovery, not before.

Also I didn't see any pg_start_backup() nor pg_stop_backup() calls in
your procedure.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


[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