Re: pg_upgrade & tablespaces

On Thu, Dec 19, 2013 at 12:49 PM, Joseph Kregloh <jkregloh(at)sproutloud(dot)com>wrote:

> [pgsql(at)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