Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 46A8B2E0044 for ; Tue, 26 Feb 2008 02:19:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94183-09 for ; Tue, 26 Feb 2008 02:19:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by postgresql.org (Postfix) with ESMTP id 267A52E0041 for ; Tue, 26 Feb 2008 02:19:35 -0400 (AST) Received: from compute2.internal (compute2.internal [10.202.2.42]) by out1.messagingengine.com (Postfix) with ESMTP id A5E96A0FAB for ; Tue, 26 Feb 2008 01:19:34 -0500 (EST) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by compute2.internal (MEProxy); Tue, 26 Feb 2008 01:19:34 -0500 X-Sasl-enc: XuzUWXqS0noqUqDYVYkHSSt7aYd++bEYfChoX77qmjAg 1204006774 Received: from [192.168.1.235] (76-191-150-176.dsl.dynamic.sonic.net [76.191.150.176]) by mail.messagingengine.com (Postfix) with ESMTPSA id 4C9A224FA6 for ; Tue, 26 Feb 2008 01:19:34 -0500 (EST) Message-ID: <47C3AF63.7080501@fastmail.net> Date: Mon, 25 Feb 2008 22:19:15 -0800 From: Darren Reed User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Retrieving data from the data files. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/345 X-Sequence-Number: 28419 For whatever reason, I seem to be plagued with issues... Whether they're hardware or operating system or a bad combination....I'm not sure yet....and I find myself needing to recover from postgres not wanting to play all too often. In looking at the database data files, I notice that in (for example) a file called /data/db/base/10819/16397, are the contents for one of the relations. The data appears to be correctly stored with NULLs for field seperators, etc. On the assumption that the raw data itself is ok, how do I get that data out? Has anyone written a program to extract data directly from the database data files without using postgres? Are there any caveats in doing so? Darren