Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TYwWj-0004kS-Ly for pgsql-admin@postgresql.org; Thu, 15 Nov 2012 10:18:30 +0000 Received: from nm19-vm7.bullet.mail.sg3.yahoo.com ([106.10.149.118]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TYwWf-0000IN-58 for pgsql-admin@postgresql.org; Thu, 15 Nov 2012 10:18:27 +0000 Received: from [106.10.166.122] by nm19.bullet.mail.sg3.yahoo.com with NNFMP; 15 Nov 2012 10:18:22 -0000 Received: from [106.10.151.186] by tm11.bullet.mail.sg3.yahoo.com with NNFMP; 15 Nov 2012 10:18:22 -0000 Received: from [127.0.0.1] by omp1012.mail.sg3.yahoo.com with NNFMP; 15 Nov 2012 10:18:22 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 400449.61313.bm@omp1012.mail.sg3.yahoo.com Received: (qmail 82717 invoked by uid 60001); 15 Nov 2012 10:18:22 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.in; s=s1024; t=1352974702; bh=xTZAdm7FwTdHugrkzJ5ved/Tzr2zN5drtgcTr0N9gd0=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=VOTKjCblPUdjNmxRKUTGrSXn8Drm/ZRqk9hb1xg1uGPA7DiJGUkLRDc8hzApn6WKNicogefOzNdL6farYoG+Ruu7oVVY3OolXhVWt7jzOvaTZFtAx/yOYKY2wkhmMTz+O7N7yIxgEdc0nDunuALE60mfn+6NanRObAGIfNcKr54= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.in; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=w85OBMYnk1JUYBYNQpdB11HjcELlP4vSzzmqJmEhCDCeOnyF9rtBAYZUmtSpndpno9wZnJI0PEJHMWZoWdB/9NE6n3dCJUP9ONwrxA/uwPV/TcvWNh1CEf3NTCgGNAwJo9ns8Jqw/y/W+fjKe/FUxJi42kohs9ssBWMXVTqgI0c=; X-YMail-OSG: sdCI3pkVM1kStq5rW49NFA8JanvKBdAcq7.XkiY1eqp_Lpi QqKoDTQ5J.o6zDg_kJtKBYtz6hmPpBu0AopgJJFZcs6JqSkypJLosQ9rdoHB Lp97iYPwUZF4V.PbnbazMkHDeMKi3x.0vlFxsetEDDZQZfTK8iakv.tIQ.7Y v32k.AulQxExSSC.SbJnNsIgZh.96AZ2nHcZpu6HFL51Iy9sucT9wdaoA92q Wxz3sjdb5nsgCrDiT58z5u5.Em4mHvNcTP.jGuH.I2aibsapPGMkBLiJdnih _eGEUn73tvp4luMkfS.5jshqFnMd1gNfNQnNzYetYhbUINKuBO1WepYA5tmh tvCL.3WgUx2zrYeWhTeTUzwS.vFIqVv5bPKzkfohuLY_5lypjg9SVurTr4g_ j1pYuCCj9feiJF28ftqs- Received: from [180.149.48.136] by web193105.mail.sg3.yahoo.com via HTTP; Thu, 15 Nov 2012 18:18:22 SGT X-Rocket-MIMEInfo: 001.001, RGVhciBhbGwgLAoKwqAgd2hlbiBpIGFtIHRyeWluZyB0b8KgIHJlc3RvcmUgYmFja3VwIGZyb20gV0FMIGZpbGVzICx0aGUgZm9sbG93aW5nIGVycm9yIGNhbWU6CgrCoMKgIGNhbm5vdCBzdGF0IGAvb3B0L3Bnc3FsYmFja3VwL3dhbHMvMDAwMDAwMDEuaGlzdG9yeSc6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3RvcnkKTE9HOsKgIHJlc3RvcmVkIGxvZyBmaWxlICIwMDAwMDAwMTAwMDAwMDAwMDAwMDAwMDMiIGZyb20gYXJjaGl2ZQpMT0c6wqAgdW5leHBlY3RlZCBwYWdlYWRkciAwL0EwMDAgaW4gbG9nIGZpbGUBMAEBAQE- X-Mailer: YahooMailWebService/0.8.123.460 Message-ID: <1352974702.81341.YahooMailNeo@web193105.mail.sg3.yahoo.com> Date: Thu, 15 Nov 2012 18:18:22 +0800 (SGT) From: Ravi Kumar Reply-To: Ravi Kumar Subject: How to restore backup To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="2118110249-1605045806-1352974702=:81341" X-Pg-Spam-Score: 0.7 (/) X-Archive-Number: 201211/83 X-Sequence-Number: 40328 --2118110249-1605045806-1352974702=:81341 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear all ,=0A=0A=A0 when i am trying to=A0 restore backup from WAL files ,t= he following error came:=0A=0A=A0=A0 cannot stat `/opt/pgsqlbackup/wals/000= 00001.history': No such file or directory=0ALOG:=A0 restored log file "0000= 00010000000000000003" from archive=0ALOG:=A0 unexpected pageaddr 0/A000 in = log file 0, segment 3, offset 40960=0ALOG:=A0 invalid primary checkpoint re= cord=0ALOG:=A0 restored log file "000000010000000000000003" from archive=0A= LOG:=A0 invalid xl_info in secondary checkpoint record=0APANIC:=A0 could no= t locate a valid checkpoint record=0ALOG:=A0 startup process (PID 5883) was= terminated by signal 6: Aborted=0ALO::=A0 aborting startup due to startup = process failure=0ALOG:=A0 database system was shut down at 2012-11-16 11:56= :34 IST=0ALOG:=A0 starting archive recovery=0A=0A=A0 can you help me?=0A=0A= =0Awith regards=0Aravi=0A --2118110249-1605045806-1352974702=:81341 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Dear all ,
=

  when i am trying to  restore backup from WA= L files ,the following error came:

   ca= nnot stat `/opt/pgsqlbackup/wals/00000001.history': No such file or directo= ry
LOG:  restored log file "000000010000000000000003" from archive<= br>LOG:  unexpected pageaddr 0/A000 in log file 0, segment 3, offset 40960
LOG:  invalid primary checkpoint record
LOG:  restor= ed log file "000000010000000000000003" from archive
LOG:  invalid x= l_info in secondary checkpoint record
PANIC:  could not locate a va= lid checkpoint record
LOG:  startup process (PID 5883) was terminat= ed by signal 6: Aborted
LO::  aborting startup due to startup proce= ss failure
LOG:  database system was shut down at 2012-11-16 11:56:= 34 IST
LOG:  starting archive recovery

&nb= sp; can you help me?


with regar= ds
ravi
--2118110249-1605045806-1352974702=:81341--