Data file recovery - Mailing list pgsql-general

From Kevin Kempter
Subject Data file recovery
Date
Msg-id 200909291639.38829.kevink@consistentstate.com
Whole thread Raw
Responses Re: Data file recovery
List pgsql-general
Hi all;

Here's my scenario:

1) we setup a db on a local server and we created an external tablespace on a
san. We loaded about 400GB in the san tablespace.

2) we had lots of HW issues, subsequently the server was re-purposed in an
emergency scenario

3) now we want the data back from the san however the original server, which
is where the postgres cluster lived (on the internal disk) that we used to
originally create this san tablespace is now gone.


So, based on the above; is it possible to recover the data on the san into a
tablespace via a new postgres cluster on a new server?

Thanks in advance

pgsql-general by date:

Previous
From: Louis Fridkis
Date:
Subject: pitr errors
Next
From: Tom Lane
Date:
Subject: Re: Data file recovery