Tablespace restore
Tablespace restore
От:
"Martin Arpon" <marpon@marpon.com.ar>
Дата:
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
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Martin Arpon" 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