Re: [GENERAL] Could not locate a valid checkpoint record

2010-06-24 Thread Norberto Delle
Em 24/6/2010 11:48, Tom Lane escreveu: Norberto Delle writes: 2010-06-24 09:00:28 PANIC: could not locate a valid checkpoint record 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? pg_r

Re: [GENERAL] Could not locate a valid checkpoint record

2010-06-24 Thread Tom Lane
Norberto Delle writes: > 2010-06-24 09:00:28 PANIC: could not locate a valid checkpoint record > 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? pg_resetxlog should allow you to restart the database, bu

[GENERAL] Could not locate a valid checkpoint record

2010-06-24 Thread Norberto Delle
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 checkpo