Re: Tablespace restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: Tablespace restore
Date
Msg-id 25140.1183687001@sss.pgh.pa.us
Whole thread Raw
In response to Tablespace restore  ("Martin Arpon" <marpon@marpon.com.ar>)
List pgsql-admin
"Martin Arpon" <marpon@marpon.com.ar> writes:
> I have a filesystem backup (cold - database was not running) of only a
> single tablespace where the database was sitting.

> Is it possible to install a new instance of PostgreSQL and in some way
> "re-mount" this tablespace recovering the database that was there?

No.  Not unless you have the pg_clog state that went with it.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Martin Arpon"
Date:
Subject: Tablespace restore
Next
From: lai yoke hman
Date:
Subject: Performance benchmarking