From: Darren Reed <darrenr@fastmail.net>
To: pgsql-admin@postgresql.org
Subject: Retrieving data from the data files.
Date: Mon, 25 Feb 2008 22:19:15 -0800
Message-ID: <47C3AF63.7080501@fastmail.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: darrenr@fastmail.net
Subject: Re: Retrieving data from the data files.
In-Reply-To: <47C3AF63.7080501@fastmail.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox