Skip site navigation (1) Skip section navigation (2)

Bug #783: WINDOWS 2000: invalid primary checkpoint record

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #783: WINDOWS 2000: invalid primary checkpoint record
Date: 2002-09-27 05:07:38
Message-ID: 20020927050738.E8DD347717A@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Le Quang Anh Ngoc (ngoc(at)unico-t(dot)co(dot)jp) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
WINDOWS 2000: invalid primary checkpoint record

Long Description
Hello,
I'm using Windows 2000, PostgreSQL 7.2.1-win32.

While System was be running, the power was interrupted and rebooted. Then I run pgsvmgr.exe again, from client machine I try to run psql.exe and login but I cannot. 

Please, help me to restore the data.
Thanks alot.



Sample Code
*The content of file pg.errors :

DEBUG:  database system was interrupted at 2002-09-20 21:03:14 JST
DEBUG:  ReadRecord: out-of-sequence SUI 2 (after 3) in log file 1, segment 108, offset 8863744
DEBUG:  invalid primary checkpoint record
DEBUG:  open of C:\postgresql-7.2.1-win32\bin\..\data\pg_xlog/0000000100000021 (log file 1, segment 33) failed: No such file or directory
DEBUG:  invalid secondary checkpoint record
FATAL 2:  unable to locate a valid checkpoint record


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: fredrik chabotDate: 2002-09-27 07:30:26
Subject: FATAL 1: LWLockAcquire: can't wait without a PROC structure
Previous:From: Tom LaneDate: 2002-09-27 04:51:59
Subject: Re: Bug #782: clog files disappear after 'vacuum;'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group