Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade & tablespaces - Mailing list pgsql-general

From Jeff Janes
Subject Re: pg_upgrade & tablespaces
Date
Msg-id CAMkU=1xvtZ0wkUEXYMT9U0ABokk=UCuXxtZg8PB9U35AF8TqeA@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade & tablespaces  (Joseph Kregloh <jkregloh@sproutloud.com>)
List pgsql-general
Tree view
On Thu, Dec 19, 2013 at 12:49 PM, Joseph Kregloh <jkregloh@sproutloud.com> wrote:
[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
lrwxr-xr-x  1 pgsql  pgsql        52 Dec 19 19:53 11047392 -> /home/jkregloh/pg_data/data/stats_staging_indexspace

Can you show the same thing on the 9.3 data directory, after the failed upgrade?

It seems to me that you guys have made a mess out of your disk layout, and pg_upgrade is struggling to preserve the mess, but failing.  What is the point of having 80 tablespaces, especially if they just point back to the same place?

Cheers,

Jeff

pgsql-general by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: Re: connect using quirrel sql client
Next
From: Joseph Kregloh
Date:
Subject: Re: pg_upgrade & tablespaces