On Thu, Dec 19, 2013 at 4:18 PM, Bruce Momjian <br...@momjian.us> wrote:
> On Thu, Dec 19, 2013 at 01:08:18PM -0800, Sergey Konoplev wrote: > > On Thu, Dec 19, 2013 at 12:49 PM, Joseph Kregloh > > <jkreg...@sproutloud.com> wrote: > > > On Thu, Dec 19, 2013 at 3:46 PM, Sergey Konoplev <gray...@gmail.com> > wrote: > > >> On Thu, Dec 19, 2013 at 12:27 PM, Joseph Kregloh > > >> <jkreg...@sproutloud.com> wrote: > > >> > So what I get from this is that it does create the correct 9.3 > files in > > >> > the > > >> > new location, however it cannot copy the relation over because the > old > > >> > data > > >> > is in the /home/jkregloh/pg_data/data/drupal_dbspace/ not in > > >> > /usr/local/pgsql/data/drupal_dbspace/ as the pg_upgrade query tries > to > > >> > do. > > >> > > >> Can you show what ls -l /home/jkregloh/pg_data/data/pg_tblspc/ prints, > > >> please? > > >> > > > [pgsql@postgres-93-upgrade ~]$ ls -l > /home/jkregloh/pg_data/data/pg_tblspc/ > > > lrwxr-xr-x 1 pgsql pgsql 41 Dec 19 19:53 11047389 -> > > > /home/jkregloh/pg_data/data/stats_dbspace > > > lrwxr-xr-x 1 pgsql pgsql 44 Dec 19 19:53 11047390 -> > > > /home/jkregloh/pg_data/data/stats_indexspace > > > lrwxr-xr-x 1 pgsql pgsql 49 Dec 19 19:53 11047391 -> > > > /home/jkregloh/pg_data/data/stats_staging_dbspace > > > > Bruce, may be it's a silly question, but the above makes me think so. > > I always keep tablespaces in locations different from the main data > > dir, and never faced something like this. > > > > Doesn't pg_upgrade do a stright replace of -d dir with -D dir > > everywhere in paths? > > pg_upgrade is looking at the data dir, the database oid, and relfilenode > to get the old path, and does the same for the new path. Tablespaces > point to the same location in old and new clusters --- only a > subdirectory PG_VERISON is different. > > Is /home/jkregloh/pg_data/data also your default cluster directory? If > so, having tablespaces inside of there will not work well as they will > continue to be stored in the old cluster's data directory. Those will > not be renamed/relocated by pg_upgrade. > > No, that is not my default cluster dir. That is just the data directory of my 9.0 install that I mounted there in order to do the pg_upgrade. Essentially that points to /usr/local/pgsql/data on my 9.0 jail. > -- > Bruce Momjian <br...@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + Everyone has their own god. + >
