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

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Is it possible to import raw data directories in a cluster (Debian)?
Date: 2011-09-07 07:13:33
Message-ID: 1315379614.4054.6.camel@panoramix.Askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

During an upgrade of by customer he managed to drop the original cluster
as the first step. As soon as he saw his error he broke off the
pg_dropcluster by ctrl-c. Of course he has no useful backups, But it
appears that the directories of the database he wants to restore are
still on disk and untouched by his upgrade.

Is it possible to import the data in the directories somehow so that
they are fully functional databases?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joost Kraaijeveld 2011-09-07 07:31:52 Re: Is it possible to import raw data directories in a cluster (Debian)?
Previous Message Lukasz Brodziak 2011-09-06 21:43:50 Re: corrupted rows in pg_attribute deleted