Обсуждение: Data file recovery

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

Kevin Kempter <kevink@consistentstate.com> writes:
> 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?

No.  If you didn't keep the core cluster (particularly the pg_clog
data), you're pretty well screwed.  Don't you have any backups?

            regards, tom lane