Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6A8DD2E0102 for ; Wed, 19 Mar 2008 11:56:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11319-02 for ; Wed, 19 Mar 2008 11:56:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.245]) by postgresql.org (Postfix) with ESMTP id 9D35C2E009C for ; Wed, 19 Mar 2008 11:56:20 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so113660ana.33 for ; Wed, 19 Mar 2008 07:56:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=Vs18qoIeww9WsZuyQX0etjKFoDUO1VRnr8syWj3GLlU=; b=NG3TfAT08QkE1PkwzppvBRNJf8CaqQ4UquAS0Iusz5RhfaBjiPJP0s9oSCHVQROKRw1jdWwNkbLH/WISC1WNnZuOnBlcdPwW8lqUbuA+4siPrVpY7Cl4YixzJFMrP/AwRndRLMUN6aeOLZQv67BwwmBveMXeTuCzzvDuc3Nwdlk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=egQRFngOgnDOEJacLlD2w/HuKpfLFmQVfiz9c+nnvBeRswrWMZ/7+LjteilJSBVVC7VO0T1NW50WOu4nvCIulDUXTtKItOueXKKtc25kHZkm/Tmt8x9vYvqTD3jM/M2yZP7PGjLYYi1mbgyACKekFyu2yZ1ieNhktocSqfg6LN0= Received: by 10.100.215.14 with SMTP id n14mr1937592ang.58.1205938579358; Wed, 19 Mar 2008 07:56:19 -0700 (PDT) Received: by 10.100.134.19 with HTTP; Wed, 19 Mar 2008 07:56:19 -0700 (PDT) Message-ID: Date: Wed, 19 Mar 2008 16:56:19 +0200 From: veejar To: pgsql-admin@postgresql.org Subject: DB Structure Recovery MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/141 X-Sequence-Number: 28624 Hello! My filesystem (UFS-FreeBSD) was crashed and I have lost files from PGSQL DATA DIR FOLDER after fsck-utility. I have lost files from directory "pg_xlog" I reset my pg_xlog. And now have such error by starting pgsql-server: LOG: database system was interrupted at 2008-03-18 22:29:48 EET LOG: checkpoint record is at 3E/6C000020 LOG: redo record is at 3E/6C000020; undo record is at 3E/6C000020; shutdown TRUE LOG: next transaction ID: 0/1624775486; next OID: 9528514 LOG: next MultiXactId: 6643; next MultiXactOffset: 13690 LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 3E/6C000068 LOG: redo is not required FATAL: could not access status of transaction 6643 DETAIL: Could not read from file "pg_multixact/offsets/0000" at offset 24576: Success. LOG: startup process (PID 6267) exited with exit code 1 LOG: aborting startup due to startup process failure LOG: logger shutting down Is it possible to lose this problem? HELP!!!