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

Can not restart postgres: Panic could not locate a valid checkpoint record

From: Mary Ellen Fitzpatrick <mfitzpat(at)bu(dot)edu>
To: PGSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Can not restart postgres: Panic could not locate a valid checkpoint record
Date: 2008-04-22 17:13:45
Message-ID: 480E1CC9.8080801@bu.edu (view raw or flat)
Thread:
Lists: pgsql-general
Hi,
I am running postgres-8.1 on a Centos5 system.
this morning when I came in there was no more disk space on the 
partition that holds pgsql: /var/lib/pgsql.
I believe postgres had crashed at this point.  I stupidly removed all of 
the files under pg_xlog to create disk space.  Not knowing that those 
are the files I need to start the database.  I  quickly realized the 
error I had made and restored the  pg_xlog data/files from our system 
backup that ran at 1am last night (4/22/08).

Now when I try to restart the database, I get the following error.   It 
is looking for file 000000010000001300000064, which I do not have. 

LOG:  database system was shut down at 2008-04-22 10:38:59 EDT
LOG:  could not open file "pg_xlog/" (log file 19, segment 100): No such 
file or directory
LOG:  invalid primary checkpoint record
LOG:  could not open file "pg_xlog/000000010000001300000064" (log file 
19, segment 100): No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 6800) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  logger shutting down

 
I am in the process of having the WAL dir restored as well.  Again, in 
my haste, I deleted that dir as well.  This data will be from 4/22/08 at 
1pm as well, time of the system backup.


If I do not have the files that startup script is asking for, what is 
the best way to restart the database.
Any advise (other than not deleting important dirs) would be greatly 
appreciated.


-- 
Thanks
Mary Ellen


Responses

pgsql-general by date

Next:From: BRUSSER MichaelDate: 2008-04-22 18:06:43
Subject: Re: Can not restart postgres: Panic could not locate a valid checkpoint record
Previous:From: Richard HuxtonDate: 2008-04-22 17:09:03
Subject: Re: can't cast char to in

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