pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dilipan Sebastiampillai <dilipan.sebastiampillai@framestore-cfc.com>
To: pgsql-admin@postgresql.org
Subject: could not locate a valid checkpoint record
Date: Fri, 09 Sep 2005 15:17:16 +0100
Message-ID: <4321996C.90603@framestore-cfc.com> (raw)

Hi all,

We had a crash with our postgresql 7.4.5 and when we rebooted we have 
this message :

 [1-1] LOG:  could not create IPv6 socket: Address family not supported 
by protocol
 [2-1] LOG:  database system shutdown was interrupted at 2005-09-08 
21:03:00 BST
[3-1] LOG:  could not open file 
"/var/lib/pgsql/data/pg_xlog/0000000000000000" (log file 0, segment 0): 
No such file or directory
[4-1] LOG:  invalid primary checkpoint record
[5-1] LOG:  could not open file 
"/var/lib/pgsql/data/pg_xlog/0000000000000000" (log file 0, segment 0): 
No such file or directory
 [6-1] LOG:  invalid secondary checkpoint record
[7-1] PANIC:  could not locate a valid checkpoint record
[2-1] LOG:  startup process (PID 24513) was terminated by signal 6
[3-1] LOG:  aborting startup due to startup process failure
 postgresql: Starting postgresql service:  failed

I tried ( after copying thes PGDATA dir obviously ) :

pg_resetxlog /var/lib/pgsql/data/ -f

After that postgreSQL starts but I realised that pg_database is empty ( 
it contains only template0 and template1 ) .
If I type "psql myDB", with myDB being a database present before the 
crash, I have access to the psql shell but a "SELECT * from myDBtable" 
gives me the right table column name but empty !!

myDB=# select * from myDBtable;
 id | use | data
----+-----+------
(0 rows)

How can I get the data back? I still have all the PGDATA/base directory.





view thread (3+ messages)  latest in thread

Message-ID: <4321996C.90603@framestore-cfc.com>
Permalink:  ../4321996C.90603@framestore-cfc.com/
Also on:    postgresql.org/message-id/4321996C.90603@framestore-cfc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: dilipan.sebastiampillai@framestore-cfc.com
  Subject: Re: could not locate a valid checkpoint record
  In-Reply-To: <4321996C.90603@framestore-cfc.com>
  References: <4321996C.90603@framestore-cfc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox