On Mon, 2011-07-18 at 16:32 -0400, Bruce Momjian wrote: > Guillaume Lelarge wrote: > > 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, I agree with your analysis. > Thanks :) -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
