X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 64D9DD8454 for ; Fri, 9 Sep 2005 11:18:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98341-05 for ; Fri, 9 Sep 2005 14:17:56 +0000 (GMT) Received: from mxout.fs-cfc.co.uk (mxout.fs-cfc.co.uk [193.203.83.15]) by svr1.postgresql.org (Postfix) with ESMTP id 573A1D8400 for ; Fri, 9 Sep 2005 11:17:56 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by mxout.fs-cfc.co.uk (Postfix) with ESMTP id 20A5A13802B for ; Fri, 9 Sep 2005 15:18:00 +0100 (BST) Received: from mxout.fs-cfc.co.uk ([127.0.0.1]) by localhost (mx-out [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 18383-08 for ; Fri, 9 Sep 2005 15:17:58 +0100 (BST) Received: from mail.admin.local (mail.admin.local [192.168.2.15]) by mxout.fs-cfc.co.uk (Postfix) with ESMTP id 0BF5E13803B for ; Fri, 9 Sep 2005 15:17:58 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by mail.admin.local (Postfix) with ESMTP id 68A2CF99A6E for ; Fri, 9 Sep 2005 15:17:17 +0100 (BST) Received: from [172.17.40.85] (sys385.prod.local [172.17.40.85]) by mail.admin.local (Postfix) with ESMTP id 3FEA3DF1E24 for ; Fri, 9 Sep 2005 15:17:16 +0100 (BST) Message-ID: <4321996C.90603@framestore-cfc.com> Date: Fri, 09 Sep 2005 15:17:16 +0100 From: Dilipan Sebastiampillai User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: could not locate a valid checkpoint record Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/95 X-Sequence-Number: 18832 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.