Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tablespace restore

Tablespace restore

From
"Martin Arpon"
Date:
Hi,

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?

The whole database was there, and there wasn't anything else.

Thanks,

Martin

Re: Tablespace restore

From
Tom Lane
Date:
"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