Re: tablespace and sequences?

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: tablespace and sequences?
Дата
Msg-id Pine.LNX.4.58.0408171732100.30419@sablons.cri.ensmp.fr
обсуждение исходный текст
Ответ на Re: tablespace and sequences?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: tablespace and sequences?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: tablespace and sequences?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tablespace and sequences?