Re: tablespace and sequences?

> 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.

How is that at all a problem?  It's no different to the requirement to 
have installed all your contrib .so's before running your restore, 
what's so hard about making a few dirs?  It's also no different to the 
old database locations support.  Personally, I think it's a non-issue.

It's also impossible to do as you suggest and have a --ignore-tablespace 
flag.  All it could do is at dump time to dump NO tablespace, which is 
NOT what you want.  At restore time it doesn't do anything since 
pg_dumpall is a text format only.

Chris