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