Re: tablespace and sequences? - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: tablespace and sequences?
Date
Msg-id Pine.LNX.4.58.0408171732100.30419@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: tablespace and sequences?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: tablespace and sequences?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
> > > and afaik it is on Bruce's Beta-TODO list too.
> > Argh, I missed this one! Is it somewhere on line?
> Yep, URL at the top:

Quite an unexpected location! thanks for the pointer.

> Current version at ftp://momjian.postgresql.org/pub/postgresql/open_items.


IMVHO, I think the following todo item should make it for 8.0:
Allow database recovery where tablespaces can't be created
When a pg_dump is restored, all tablespaces will attempt to be       created in their original locations. If this
fails,the user must       be able to adjust the restore process.
 

Indeed, if someone step to 8.0, make some use of tablespace, and connot
move its databases because of this issue, I guess she will not going to be
happy at all... I guess something like "--ignore-tablespace" at the
restoration phase would be good. At the dump phase it would be a minimum.

-- 
Fabien Coelho - coelho@cri.ensmp.fr


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: tablespace and sequences?
Next
From: Tom Lane
Date:
Subject: Re: tablespace and sequences?