Bug #783: WINDOWS 2000: invalid primary checkpoint record
PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2002-09-27T05:07:38Z
Lists: pgsql-bugs
Le Quang Anh Ngoc (ngoc@unico-t.co.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