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
FAQ