Re: Tablespace restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Martin Arpon" <marpon(at)marpon(dot)com(dot)ar>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Tablespace restore
Date: 2007-07-06 01:56:41
Message-ID: 25140.1183687001@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Martin Arpon" <marpon(at)marpon(dot)com(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lai yoke hman 2007-07-06 02:23:35 Performance benchmarking
Previous Message lai yoke hman 2007-07-06 01:02:12 Performance benchmarking