Re: error during PITR

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

 



Karuna Karpe <karuna.karpe@xxxxxxxxxxxxxxx> wrote:
 
> 2011-12-23 11:44:18 ISTLOG:  restored log file
> "00000001000000000000000F" from archive
> 2011-12-23 11:44:18 ISTLOG:  record with incorrect prev-link
> 0/E000094 at 0/F000020
> 2011-12-23 11:44:18 ISTLOG:  redo done at 0/E0000C0
> 2011-12-23 11:44:18 ISTLOG:  restored log file
> "00000001000000000000000E" from archive
> 2011-12-23 11:44:18 ISTFATAL:  WAL ends before consistent recovery
> point
> 2011-12-23 11:44:18 ISTLOG:  startup process (PID 4435) exited
> with exit code 1
> 2011-12-23 11:44:18 ISTLOG:  terminating any other active server
> processes
> 
> Can please any one give me solution for that as soon as possible?
 
It looks like you don't have a good copy of the
00000001000000000000000F WAL file.  If you can retrieve a good copy
from somewhere, you should be able to proceed.  If not, you should
go to an earlier base backup -- that will let you restore a
consistent version of the database for as far as you have good WAL
files.
 
You should also review your procedure for copying WAL files.  We had
occasional problems like this when we were using samba shares; we've
had none since we copied the files to a directory on the database
server and used rsync to copy them off.
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[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