pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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