Re: Getting database data from the PostgreSQL file system

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Ewgenij Sokolovski <ewgenijkkg(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting database data from the PostgreSQL file system
Date: 2009-08-14 15:42:18
Message-ID: 407d949e0908140842l7b42b76bv89b99bae6a518834@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 14, 2009 at 4:31 PM, Ewgenij Sokolovski<ewgenijkkg(at)gmx(dot)de> wrote:
> Hello, Guys! Is that kind of thing possible at all? We have a problem that our database is corrupted, and we are not able to get any table data by executing SQL requests/running the PG_Admin tool. So, we thought, maybe it is possible to retrieve data by accessing the data storage directly. The data folder of PostgreSQL is there, so, theoretically, we should be able to retrieve all we need, shouldn't we?:)

In theory yes, in practice the tool to do it would look a lot like postgres...

What corruption symptoms are you actually seeing?

--
greg
http://mit.edu/~gsstark/resume.pdf

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Spinassi 2009-08-14 16:30:39 Proxy for postgres
Previous Message Serge Fonville 2009-08-14 15:41:54 Re: Getting database data from the PostgreSQL file system