pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Tablespace restore 2+ messages / 2 participants [nested] [flat]
* Tablespace restore @ 2007-07-06 00:56 Martin Arpon <marpon@marpon.com.ar> 2007-07-06 01:56 ` Re: Tablespace restore Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Martin Arpon @ 2007-07-06 00:56 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Tablespace restore 2007-07-06 00:56 Tablespace restore Martin Arpon <marpon@marpon.com.ar> @ 2007-07-06 01:56 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-07-06 01:56 UTC (permalink / raw) To: Martin Arpon <marpon@marpon.com.ar>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-07-06 01:56 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-07-06 00:56 Tablespace restore Martin Arpon <marpon@marpon.com.ar> 2007-07-06 01:56 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox