Re: Is it possible to import raw data directories in a cluster (Debian)?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Is it possible to import raw data directories in a cluster (Debian)?
Date: 2011-09-07 17:40:34
Message-ID: 4E6766420200002500040E73@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> wrote:

>> I thought you said that pg_dropcluster was what was
>> run? When you say the directories are "untouched" does that mean
>> that no files have been deleted from them?
> Apart from the postgres and template* databases...

Ah, if the directories containing the data had not yet been touched,
an expert might be able to extract the data. It would take a lot of
skill and a lot of time (read "not inexpensive to do"), but if
you're right about the files being there in the application
database(s), it might be done.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-09-07 18:04:52 Re: Query problem
Previous Message Joost Kraaijeveld 2011-09-07 17:22:35 Re: Is it possible to import raw data directories in a cluster (Debian)?