Re: pg_upgrade does not translate tablespace location to new cluster

On Fri, 2011-07-01 at 18:30 +0200, Olivier LEVESQUE wrote:
> Guillaume,
>
> Thank you for your answer,
>
>
> >> Creating databases in the new cluster
> >> psql:/opt/pgsql/bin/pg_upgrade_dump_globals.sql:38: ERROR: directory
> >> "/pgqdata/pgserver01/data/tbs_ptest/PG_9.0_201008051" already in use
> >> as a tablespace
> >>
> >
> > That would mean that you have a 9.0 tablespace in
> > the /pgqdata/pgserver01/data/tbs_ptest directory. Is it true? and IIUC
> > your directory layout, it shouldn't.
> >
>
> Yes, you're right. This directory was here from my last succesfull pg_upgrade.
>
> But the problem is that now, data of the new cluster is scattered
> across two paths which is not what I expected.
>
>
> > The only way is to change the code. It shouldn't be too hard, but is
> > potentially dangerous.
>
> Why dangerous ? It could be an option.
>

I didn't mean the option is dangerous. My point is: I don't think it
would be interesting to add this change to the mainstream pg_upgrade
because the usecase is very limited (others will correct me if I'm
wrong), so the other option is to code it yourself. And this might be
dangerous (because of very limited tests, and so forth).

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com