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