Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A365A2E0033 for ; Tue, 26 Feb 2008 06:16:14 -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 36490-04 for ; Tue, 26 Feb 2008 06:16:11 -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 F23972E003E for ; Tue, 26 Feb 2008 06:16:11 -0400 (AST) Received: from compute2.internal (compute2.internal [10.202.2.42]) by out1.messagingengine.com (Postfix) with ESMTP id A3B7A9E5BC for ; Tue, 26 Feb 2008 05:16:10 -0500 (EST) Received: from heartbeat1.messagingengine.com ([10.202.2.160]) by compute2.internal (MEProxy); Tue, 26 Feb 2008 05:16:10 -0500 X-Sasl-enc: kiJDOCzur1BSPx4fNejak2VeTMkzn5IVZf+FyhwR9Ulm 1204020970 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 2752D177D1 for ; Tue, 26 Feb 2008 05:16:09 -0500 (EST) Message-ID: <47C3E6D6.50902@fastmail.net> Date: Tue, 26 Feb 2008 02:15:50 -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/341 X-Sequence-Number: 28415 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