Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 41C232E005E for ; Fri, 21 Mar 2008 05:47:54 -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 63917-04 for ; Fri, 21 Mar 2008 05:47:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail129143.authsmtp.com (outmail129143.authsmtp.com [62.13.129.143]) by postgresql.org (Postfix) with ESMTP id E53B82E0061 for ; Fri, 21 Mar 2008 05:47:50 -0300 (ADT) Received: from squirrel.dmpriest.net.uk (squirrel.dmpriest.net.uk [62.13.128.25]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m2L8lmQh026138; Fri, 21 Mar 2008 08:47:48 GMT Received: from [192.168.0.3] (85-211-64-98.dyn.gotadsl.co.uk [85.211.64.98]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m2L8llZU031974; Fri, 21 Mar 2008 08:47:47 GMT Subject: Re: DB Structure Recovery From: Simon Riggs To: veejar Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Fri, 21 Mar 2008 08:48:59 +0000 Message-Id: <1206089339.4285.633.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 7b125618-f723-11dc-b66f-001871e930f4 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagRbYFhD HGQLW1xEUFV7XWR/ bw0fZQBDYEtPQQNu TkFBXVBXCwUmXB59 DkJCOHxydARPf3o+ ZE5rWD5cDkV4cEB8 SlMCEm8FeGZhPDMC AkZeIR5UcAJCeR4Q Y1N/AndDAzANdhER MyoSGQV5ER8XEzhP XwoRMEgfCXwGFTki SgoTdXVz X-Authentic-SMTP: 61633235383639.cat.dmpriest.net.uk:787/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/184 X-Sequence-Number: 28667 On Wed, 2008-03-19 at 16:56 +0200, veejar wrote: > 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!!! It is possible to recover some data in most situations, but it can take anywhere from a day or two. My company offers database recovery services, if you're willing to pay. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk