Re: [GENERAL] pg_upgrade does not translate tablespace location to new cluster

2011-07-18 Thread John R Pierce
On 07/18/11 1:59 PM, Guillaume Lelarge wrote: Guillaume, I agree with your analysis. > Thanks :) Can we please trim quotes on responses? We really don't need a regurgitation of the entire 40 preceding messages to say 'thanks', just the part that you are referencing will suffice. If yo

Re: [GENERAL] pg_upgrade does not translate tablespace location to new cluster

2011-07-18 Thread Guillaume Lelarge
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_upg

Re: [GENERAL] pg_upgrade does not translate tablespace location to new cluster

2011-07-18 Thread Bruce Momjian
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/da

Re: [GENERAL] pg_upgrade does not translate tablespace location to new cluster

2011-07-01 Thread Guillaume Lelarge
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 u

Re: [GENERAL] pg_upgrade does not translate tablespace location to new cluster

2011-07-01 Thread Olivier LEVESQUE
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

Re: [GENERAL] pg_upgrade does not translate tablespace location to new cluster

2011-07-01 Thread Guillaume Lelarge
On Fri, 2011-07-01 at 16:24 +0200, Olivier LEVESQUE wrote: > Hi, > > I am currently testing pg_upgrade (in copy mode) to migrate a 8.4.4 > old cluster to a new 9.0.3 one. > It runs fine except when databases contain tablespaces > > > $pg_upgrade -d /pgqdata/pgserver01/data -D /pgqdata/pgserver0