Re: Data file recovery

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