Could not locate a valid checkpoint record

From: Norberto Delle <betodelle(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Could not locate a valid checkpoint record
Date: 2010-06-24 12:34:48
Message-ID: 4C2350E8.10506@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I tried to start a PostgresSQL instance this morning, but it failed. So
I checked the log:

2010-06-24 09:00:28 LOG: database system was shut down at 2010-06-24
08:13:58

2010-06-24 09:00:28 LOG: record with zero length at 9/E0E9D200

2010-06-24 09:00:28 LOG: invalid primary checkpoint record

2010-06-24 09:00:28 LOG: record with zero length at 9/E0E9D1B0

2010-06-24 09:00:28 LOG: invalid secondary checkpoint record

2010-06-24 09:00:28 PANIC: could not locate a valid checkpoint record

This application has requested the Runtime to terminate it in an unusual
way.

Please contact the application's support team for more information.

2010-06-24 09:00:28 LOG: startup process (PID 1644) exited with exit code 3

2010-06-24 09:00:28 LOG: aborting startup due to startup process failure

2010-06-24 09:00:29 LOG: logger shutting down

I know this error requires you to restore from backup, but,
unfortunatelly, we have no backup.
There is any way I can recover the data?

Thanks

Norberto

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2010-06-24 12:40:04 complicated running aggregate
Previous Message Karsten Hilbert 2010-06-24 12:19:37 Re: copy/duplicate database schemas